Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500? a) select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null; b) select job, sum(Sal) from Emp where comm is null group by job having sum(Sal) > 2500; c) select job, sum(Sal) from Emp where sum(Sal) > 2500 and comm is null group by job; d) select job, sum(Sal) from Emp group by job having sum(Sal) > 2500 and comm is not null;

Lab #9 – Joining Data From Multiple Tables List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Use an INTERSECT operator.   Lab #10 – Sub Queries Find the sales rep number, last name, and first name for every sales rep who represents at least one customer with a credit limit of $2000.     List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron.       Down below are the tables ORDER_LINE ORLN_ORDER_NUMBER               ORLN_PART_NUMBER ORLN_NUMBER_ORDERED          ORLN_QUOTED_PRICE   ORDER_TABLE ORDR_ORDER_NUMBER               ORDR_ORDER_DATE               ORDR_CUSTOMER_NUMBER   CUSTOMER CUST_NUMBER CUST_LAST         CUST_FIRST        CUST_STREET     CUST_CITY          CUST_STATE        CUST_ZIP_CODE               CUST_BALANCE CUST_CREDIT_LIMIT       CUST_SALES_REP_NUM               PART PART_NUMBER  PART_DESCRIPTION         UNITS_ON_HAND…

Write the SQL code that will produce the results shown as below. Write the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table. Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS. Write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked. The result is shown as below.

which type of joins is not supported by SQL Inner joins Right Joins Full Joins left joins

query no 2 is select avg(CustBal) from Customer where CusState='WA' GROUP BY city. Here aggregate function avg is used to calculate average of customer balance.next where statement is used to filter the customer who live in Washington state and at last group by clause is used to show the balance city wise.

Find the output of the following query based on the table given below. SELECT AVG(fees), course_id FROM student GROUP BY course_id ORDER BY course_id DESC: Table Name: student Course_id Coursename Fees 1001 C++ 3000 1002 MATHS for IT 2000 1002 MATHS for IT 4000 O a. 1002. 3000, 1500, 1001 O b. 4000, 1002, 3000, 1001 O. 2000, 1002. 1500, 1001 O d. 3000,1002. 3000, 1001

Problem 53 LargeCo is planning a new promotion in Alabama (AL) and wants to know about the largest purchases made by customers in that state. Write a query to display the customer code, customer first name, last name, full address, invoice date, and invoice total of the largest purchase made by each customer in Alabama. Be certain to include any customers in Alabama who have never made a purchase; their invoice dates should be NULL and the invoice totals should display as 0. Sort the results by customer last name and then first name (Partial result are shown in Figure P7.53).

Lab #9 – Joining Data From Multiple Tables List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron. Use an INTERSECT operator.   Lab #10 – Sub Queries Find the sales rep number, last name, and first name for every sales rep who represents at least one customer with a credit limit of $2000.     List the order number and order date for every order that was placed by Mary Nelson and that contains an order line for an iron.     Repeat the exercise from the prior step using the ANY operator in the query instead of the ALL operator.