Answer to Question #246942 in Databases | SQL | Oracle | MS Access for Captain

Question

. Create a table Customers(CUSTOMER_ID, CUST_FIRST_NAME, CUST_LAST_NAME, CUST_ADDRESS, CUST_INCOME)

Create a table Orders(ORDER_ID, ORDER_DATE, CUSTOMER_ID, ORDER_TOTAL)

For each of the above attributes, define their corresponding data types as per your understanding.

Write an SQL query to Insert 6 tuples to each table

Write an SQL query to fetch the details of customers who lives in 'Delhi'.

Write an SQL query to print details of the customers whose FIRST NAME ends with ‘s’ and contains 'five' alphabets.

Write an SQL query to find the maximum of order total from orders table.

Write an SQL query to print details of customers excluding customer address as "Delhi" and "Bombay".

Write an SQL query to fetch customer id of the customers having maximum income and group by first name.

Write a SQL query to print the customer details whose income lies between 40000 to 60000.

Write an SQL query to print details of the Employee whose FIRST NAME ends with ‘n’ and s.

Answer 1

Dear Captain, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order