Question

Consider a table customer having the fields ID, First_name, Last_Name, Age, Address and salary. This table is populated with related data. Write a query to do the following. 1. Select the record where Name is Priya and Father_name is vijay. 2. Arrange the records of the table in ascending order of the age of the students 3. Arrange the records of the table in descending order of age of the student. II) Write select statements for the following key words 1. OR 2. AND 3. NOT 4. GROUP BY 5. ORDER BY

Answer 1

Answer:

1) slect first_name,last_name where first_name=priya and last_name=vijay

2)select * from customer order by age asc

3) select * from customer order by age desc

pls mark me brainliest