Where cid is the primary key. cname and occupation do not accept null values. Payment_mode accepts only cash or credit entries. The default address is “Flacq”. customer is at least 18 years old. Salary is above Rs 25000. Consider the schema of Customer table in part(a) and write SQL statements for the following queries. Using SQL, write the command to add a new column in the customer table with the following data definition; (Column “gender” of char data type and field size of 1). Write the SQL query to display the cid and gender of all employees. Write the SQL code to list all supervisors whose salary is greater than Rs 30000. Write the SQL query to set salary of all administrators to Rs 50 000.
The last session of the workshop was focused on SQL.
(a) Write the sql syntax to create a table name customer with the following restrictions;
Customer(cid, cname, address, age, occupation, salary, payment_mode)
(b)
Where
cid is the primary key.
cname and occupation do not accept null values. Payment_mode accepts only cash or credit entries. The default address is “Flacq”.
customer is at least 18 years old.
Salary is above Rs 25000.
Consider the schema of Customer table in part(a) and write SQL statements for the following queries.
-
Using SQL, write the command to add a new column in the customer table with the following data definition; (Column “gender” of char data type and field size of 1).
-
Write the SQL query to display the cid and gender of all employees.
-
Write the SQL code to list all supervisors whose salary is greater than Rs 30000.
-
Write the SQL query to set salary of all administrators to Rs 50 000.
-
Write the SQL query to display details of customers whose names start with character 'e'.
-
Write the SQL code to display details of those customers who come from Triolet or Trianon.
-
Write the SQL code to list details of customers in descending order of age.
-
Write the SQL code to show details of customers where salary is greater than Rs 36000 and
age is between 30 and 45.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 11 images