Orders Columns: order_id (int), order_no (char(30)), customer_name (char(100)) Order_Line Columns: line_id (int), order_id (int), amount (float) Which SQL statement will return an average amount for each Customer? Results must include Customers that have more than 10 Ord OA: SELECT o.customer_name, avg(ol.amount) FROM orders o, order_line ol WHERE ol.order_id = 0.order_id GROUP BY o.customer name HAVING count (DISTINCT o.order_id) > 10 B: SELECT 0.customer_name, avg(ol.amount) FROM orders o, order line ol

Orders Columns: order_id (int), order_no (char(30)), customer_name (char(100)) Order_Line Columns: line_id (int), order_id (int), amount (float) Which SQL statement will return an average amount for each Customer? Results must include Customers that have more than 10 Ord OA: SELECT o.customer_name, avg(ol.amount) FROM orders o, order_line ol WHERE ol.order_id = 0.order_id GROUP BY o.customer name HAVING count (DISTINCT o.order_id) > 10 B: SELECT 0.customer_name, avg(ol.amount) FROM orders o, order line ol

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Please provide two customer-writer arguments. Please answer my question in the specified section. according to computer experts.
SQL: Dog DataIn each question below, you will define a new table based on the following tables.CREATE TABLE parents ASSELECT "abraham" AS parent, "barack" AS child UNIONSELECT "abraham" , "clinton" UNIONSELECT "delano" , "herbert" UNIONSELECT "fillmore" , "abraham" UNIONSELECT "fillmore" , "delano" UNIONSELECT "fillmore" , "grover" UNIONSELECT "eisenhower" , "fillmore";CREATE TABLE dogs ASSELECT "abraham" AS name, "long" AS fur, 26 AS height UNIONSELECT "barack" , "short" , 52 UNIONSELECT "clinton" , "long" , 47 UNIONSELECT "delano" , "long" , 46 UNIONSELECT "eisenhower" , "short" , 35 UNIONSELECT "fillmore" , "curly" , 32 UNIONSELECT "grover" , "short" , 28 UNIONSELECT "herbert" , "curly" , 31;CREATE TABLE sizes ASSELECT "toy" AS size, 24 AS min, 28 AS max UNIONSELECT "mini" , 28 , 35 UNIONSELECT "medium" , 35 , 45 UNIONSELECT "standard" , 45 , 60;Q1: Size of DogsThe Fédération Cynologique Internationale classifies a standard poodle as over 45 cm and up to 60 cm.The sizes table…
Please use following table information to answer the exercises.SQL> DESC DEPARTMENTSName Null? Type----------------------------------------- -------- ----------------------------DEPARTMENT_ID NOT NULL NUMBER(4)DEPARTMENT_NAME NOT NULL VARCHAR2(30)MANAGER_ID NUMBER(6)LOCATION_ID NUMBER(4) SQL> DESC EMPLOYEESName Null? Type----------------------------------------- -------- ----------------------------EMPLOYEE_ID NOT NULL NUMBER(6)FIRST_NAME VARCHAR2(20)LAST_NAME NOT NULL VARCHAR2(25)EMAIL NOT NULL VARCHAR2(25)PHONE_NUMBER VARCHAR2(20)HIRE_DATE NOT NULL DATEJOB_ID NOT NULL VARCHAR2(10)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(2,2)MANAGER_ID NUMBER(6)DEPARTMENT_ID NUMBER(4) 12. Display the last name, hire date, and day of the week on which the employee started. Label the columnDAY. Order the results by the week starting with Monday.
Please help from attached file. Find the distinct number of workers who work in the HR department and who earn more than ₹250,000. Find the last name and title of all workers and the department they work in who earn less than the average salary. What is the average salary paid for all workers in each department? List the department, the average salary for the department, and the number of workers in each department. Name the average column 'AvgSal' and the number of workers column to 'Num'. What is the total compensation for each worker (salary and bonus) on a per monthly basis? List the name of the worker, their title, and the their monthly compensation (annual compensation divided by 12). Change the header for compensation to 'MonthlyComp' and round it to the nearest whole number. List the full names of all workers in all capital letters who did not get a bonus. What are the full names of all workers who have 'Manager' in their title. Do not "hard code" the titles; use string…
31 Refer to the given SQL statement. SELECT PRODNUM, PRODNAME FROM PRODUCT: Which line designates a product number of at least 300 when added to the end of this statement? O WHERE PRODNUM>=300 WHERE PRODNUM=300+ O WHERE PRODNUM=(300; unlimited) WHERE PRODNUM=>300
WEEK 9 ASSIGNMENT#3 Part I: Complete the following exercise: Create the following table with the correct columns. Call your new table: student_course (see below). Populate this table with four rows. Make sure the student id column contains values that are also in the student id column of your student table. student id course id semester year Join the student and student_course table where the student id values are the same. Join the student and student_course table where the student id values are the same and year is equal to 2020. Create a select statement that will return the length of the last name column by joining the student and student_course table where the student id values are the same and enroll month is June. Once you have completed your assignment, copy and paste the script into a Word document. Part II: Complete the following exercise: Using a subquery, select student first name where the student is in the student course table. Using a subquery, select the…
You may use the Boolean operator to search for data on two separate topics at once. To get the most relevant results, Kevin should utilize which of the following Boolean operators?