Question: 1. Create a table called Customer with the following structure. [1 mark] NAME Customer ID Name Age Salary Customer. ID as Primary Key TYPE Number

1. Create a table called Customer with the following structure. [1 mark] NAME Customer ID Name Age Salary Customer. ID as Primary Key TYPE Number (5) Varchar (20) Number (6) Number (6) 2. Insert the following values into Customer table. [1 mark] Customer. DD 15 Age 34 Salary 5500 12 30 4600 Name Ahmed Ali Mohmmed Yasser Sami 14 36 6200 10 32 7100 11 41 8000 3. Modify the column width (15) and data type(char)of the Name field of Customer table [1 mark] 4. Display the records in the Customer table Order by Customer ID. [1 mark] 5. Display the details of customers who's the Frist letter of their name is A[1 mark] 6. Update the customer name to Khalid whose salary is greater than 7000. [1 mark] 7. Determine the sum and average salary and rename the column as sum salary and ave salary. [1 mark] 8. Count the total number of rows in the customer table. [1 mark] 9. Write the following word 'hello world' in capital letter. [.5 mark] 10. Calculate the square root of the salary of all customers. [.5 mark] 11. Display the last date of that month in '09-aug-20. [.5 mark]| 12. Add two months to the system date. [.5 mark]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
