I have a doubt in query

Can you describe me little on how to run table 1 ques. C query. I tried so many queries but nothing is working, some are giving blank output. I don't understand what to do now. My submission date of the project is today.