Identify the type of code used by a trading company Ms. Ahana Ltd.:
Codes | Accounts |
CA005 | Super Ltd. |
CA006 | Regina Ltd. |
CA007 | Nasir & Sons Ltd. |
(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 :