Consider the following tables:
Write SQL queries for the following:
(i) To delete those records from table SALES whose UnitsSold is less than 80.
(ii) To display names of all products whose category is not known.
(iii) To display the product names along with their corresponding units sold.
Given the following tables:
Write SQL queries for the following:
(i) To display the number of students from each city.
(ii) To find the average age of all students.
(iii) To list the names of students and their grades.
(i) Write the SQL statement to create a table, Customer with the following specifications:
(ii) Write the SQL query to display all records in descending order of LName from the Table Customer.
With respect to SQL, match the function given in column-II with categories given in column-I :