Chapter 12, Problem 1MC

Display the customer ID, name, and order ID for all customer orders. For those customers who do not have any orders, include them in the display once by showing order ID 0.

A subquery must be placed in the outer query's HAVING clause if:     1.The subquery returns more than one value to the outer query.     2The value returned by the inner query is to be compared to grouped data in the outer query.       3.The inner query needs to reference the value returned to the outer query.         4.None of the above. Subqueries can't be used in the outer query's HAVING clause.

You need to find out the names of all employees who belong to the same department as the employee 'Jessica Butcher' who is in department 100 and has an employee ID 40. Which of the following queries will be correct? EMPLOYEES Туре NOT NULL NUMBER(4) VARCHAR2(10) Name Null? EMP ID FIRST NAME VARCHAR2(10) VARCHAR2(9) VARCHAR2(4) LAST NAME JOB MGR HIRE DATE DATE SALARY NOT NULL NUMBER COMM PCT NUMBER(7,2) DEPT ID NUMBER(2) DEPARTMENTS Туре NUMBER VARCHAR2(20) VARCHAR2(20) Name Null? DEPT ID DEPT NAME DEPT LOC O SELECT first_name, last_name FROM employees WHERE last_name = 'Butcher' And first_name = 'Jessica'; O SELECT first_name, last_name FROM employees WHERE department =100; O SELECT first_name, last_name FROM employees WHERE department = (SELECT department FROM employees WHERE first_name = 'Jessica' AND last_name = 'Butcher'); O SELECT first_name, last_name FROM employees WHERE department (SELECT department FROM employees WHERE first_name = 'Jessica' AND last_name = 'Butcher' AND…

26.In the given query, SPNAME is salesperson name, SPNUM is salesperson number, and CUSTNUM is customer number. SELECT SPNAME FROM SALESPERSON WHERE SPNUM= (SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772): What is this subquery determining? A: Which salesperson number is associated with customer number 772 B: Which customer number is associated with 772 salesperson C: Which salesperson number is associated with 772 customers D: which customer number is associated with salesperson number 772

Which of the following SQL statements displays the all unique job ids from the WORKERS table? A. SELECT job_id FROM WORKERS; C. SELECT DIST job_id FROM WORKERS; B. SELECT DISTINCT (job_id) FROM WORKERS; D. SELECT * FROM WORKERS;

Write a query that returns all customers listed in the orders table who placed orders on the most recently recorded day, return the OrderID, the CustomerID and the OrderDate .

Write the SQL code to find the average Assign_Charge by Job_code  from the Assignment table.  Write the SQL code to find the average Assign_Charge by employee  from the Assignment table.   Write the SQL code to find who works  the most and the least with one’s charging_hour  from the Assignment table.  Write the SQL code to find how many employees are in job_code 501. Write the SQL code to find what is the job description of job_code 507 Write the SQL codes to find how many projects  are available.

Q5: From the Customer table given below write SQL queries for the following question?  Write a query to display the record of the last name and city with unique state? Write a query to display the record of the distinct cities of the customers? Write a query to display the records of customers' address whose names contain letter “a”?

Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer. To do this, you can group the result set by the EmailAddress and OrderID columns. In addition, you must calculate the order total from the columns in the OrderItems table. Write a second SELECT statement that uses the first SELECT statement in its FROM clause. The main query should return two columns: the customer�s email address and the largest order for that customer. To do this, you can group the result set by the EmailAddress column.