Give a suitable example of a table with sample data and illustrate Primary and Alternate Keys in it.

Give a suitable example of a table with sample data and illustrate Primary and Alternate Keys in it.

Consider the following tables CARDEN and CUSTOMER and answer (b) and (c) parts of question:

TABLE: CARDEN

TABLE: CUSTOMER

Write SQL commands for the following statements:

1. To display the names of all the silver colored
2. To display name of car, make and capacity of cars in descending order of their sitting
3. To display the highest charges at which a vehicle can be hired from
4. To display the customer name and the corresponding name of the cars hired by them

Consider the following tables CARDEN and CUSTOMER and answer (b) and (c) parts of question:

TABLE: CARDEN

TABLE: CUSTOMER

Give the output of the following SQL queries:

1. SELECT COUNT(DISTINCT Make) FROM CARDEN;
2. SELECT MAX(Charges),MIN(Charges) FROM CARDEN;
3. SELECT COUNT(*),Make FROM CARDEN;
4. SELECT CarName FROM CARDEN WHERE Capacity=4;