Question

Write a query to display list of students name and their department name who are all from 'Coimbatore'. Sort the result based on students name

Answer 1

Answer:

Select students_name, department from table_name where city="Coimbatore". Explanation: Select chooses columns to display.

Explanation:

Answer 2

Answer:

see the image file

Explanation: