Which of the following is a valid SQL statement?a. ALTER TABLE secustomersspent ADD DATE lastorder;b. ALTER TABLE secustomerorders DROP retail;c. CREATE TABLE newtable AS (SELECT * FROM customers);d. ALTER TABLE drop column *;

Examine the EMPLOYEES table and the given SQL statement: EID Name Dept Salary 1001 Aminah IT 600 1002 Zainab Admin 400 1003 Tafal IT SELECT Name, Dept, Salary FROM employees WHERE name LIKE'_a%' AND salary IS NULL; Which of the following will be the output after executing the statément? a. Name Dept Salary Tafal IT b. Name Dept Salary Aminah IT 600 Zainab Admin 400 Name Dept Salary Zainab Admin 400 Name Dept Salary Aminah IT 600 DELL

THIS MODULE IS ABOUT SUBQUERIES, SO YOU MUST USE SUBQUERIES INSTEAD OF TABLE JOINS  (a) From which two fields in which table can you calculate the enrollment of a section?(b) From which table can you get both course and section numbers?(c) Which field in table SECTION uniquely identifies a section, section id or section no?(d) Write a SQL statement to show sections and their enrollment.(e) Write a SQL statement to show sections with enrollment greater than five. Display both course andsection numbers

SELECT customer.LastName, COUNT(Orders.OrderID) As NumberOfOrdersFROM orders, customersWHERE customer.customerID = Orders.CustomerIDGROUP BY LastNameHAVING COUNT(Orders.OrderID) > 18;a) What is the purpose of the COUNT function in this SQL statement? 2b) What is the purpose of the GROUP BY command in this SQL statement? 3c) What is the purpose of the HAVING command in this SQL statement? 3d) How would you modify this SQL query so that it shows the orders for customers 2called ‘Smith’ regardless of how many orders have been made?

Complete the SQL statement to generate the Result table. The column names in the SELECT clause must match the Result table exactly. Order Part • OrderCode PartNumber R58 492 Quantity 4 • PartNumber PartName Price 662 Z23 492 3 492 Wingding Buzzer 11 0.4 A36 662 1 R61 827 1 SELECT /* Type your code here */ FROM Order, Part WHERE /* Type your code here */ Result OrderCode PartName Order.PartNumber Buzzer 492 R58 Z23 Buzzer 492 A36 Wingding 662

5- Examine the STUDENTS table and the given SQL statement:   EID Name Dept Salary 1001 Aminah IT 600 1002 Zainab Admin 400 1003 Tafal IT       SELECT Name, Dept, SalaryFROM studentsWHERE name LIKE ‘_a%’ AND salary IS NOT NULL;  Which of the following will be the output after executing the statement?   a.   Name Dept Salary Zainab Admin 400   b.   Name Dept Salary Tafal IT     c.   Name Dept Salary Aminah IT 600   d.   Name Dept Salary Zainab Admin 400 Tafal IT

Which of the following SQL statements determines how many total customers were referred by other customers? (refer to the tables in the JustLee Books database.)a. SELECT customer#, SUM(referred)FROM customersGROUP BY customer#;b. SELECT COUNT(referred)FROM customers;c. SELECT COUNT(*)FROM customers;d. SELECT COUNT(*)FROM customersWHERE referred IS NULL;

i. What Is A Savepoint Command? ii. What Are Pseudo-columns? iii. How Can You Use Pseudo Columns In Procedural Statements? iv. How Can You Check If An Update Statement In Pl/sql Is Successfully Executed?

Write the following SQL Statements: Write a SELECT statement that returns one row for each customer that has orders with these columns: The email_address from the Customers table A count of the number of orders The total amount for each order (Hint: First, subtract the discount amount from the price. Then, multiply by the quantity.) Return only those rows where the customer has more than 1 order. Sort the result set in descending sequence by the sum of the line item amounts. Write a SELECT statement that answers this question: What is the total amount ordered for each product? Return these columns: The product name from the Products table The total amount for each product in the Order_Items (Hint: You can calculate the total amount by subtracting the discount amount from the item price and then multiplying it by the quantity) Use the ROLLUP operator to include a row that gives the grand total. Write a SELECT statement that answers this question: Which customers have ordered more…