(2) Consider the following Orders table. Write one SQL query that will compute the following from this table: (i) total number of orders, (ii) average purchase amount, (iii) maximum purchase amount, (iv) minimum purchase amount, and (v) total number of customers with purchase amounts greater than $1000. ord_no purch_amt ord_date customer_id salesman_id 70001 150.50 2012-10-05 3005 5002 70009 270.65 2012-09-10 3001 5005 70002 65.26 2012-10-05 3002 5001 70004 110.50 2012-08-17 3009 5003 70007 948.50 2012-09-10 3005 5002 70005 2400.60 2012-07-27 3007 5001 70008 5760.00 2012-09-10 3002 5001 70010 1983.43 2012-10-10 3004 5006 70003 2480.40 2012-10-10 3009 5003 70012 250.45 2012-06-27 3008 5002 70011 75.29 2012-08-17 3003 5007 70013 3045.60 2012-04-25 3002 5001

(2) Consider the following Orders table. Write one SQL query that will compute the following from this table: (i) total number of orders, (ii) average purchase amount, (iii) maximum purchase amount, (iv) minimum purchase amount, and (v) total number of customers with purchase amounts greater than $1000. ord_no purch_amt ord_date customer_id salesman_id 70001 150.50 2012-10-05 3005 5002 70009 270.65 2012-09-10 3001 5005 70002 65.26 2012-10-05 3002 5001 70004 110.50 2012-08-17 3009 5003 70007 948.50 2012-09-10 3005 5002 70005 2400.60 2012-07-27 3007 5001 70008 5760.00 2012-09-10 3002 5001 70010 1983.43 2012-10-10 3004 5006 70003 2480.40 2012-10-10 3009 5003 70012 250.45 2012-06-27 3008 5002 70011 75.29 2012-08-17 3003 5007 70013 3045.60 2012-04-25 3002 5001

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

Write PL/SQL coomands for the following question5. Table student( name,age,inter_mark,entrance_rank,address,contact_no,ID,branch)Admission( college_name,mode( pay/free/star/NRI), date,ID)a) Write a query to display the students who are all admitted on starmode branchwiseb) Display the college under which maximum NRI student admittedc) Display the college which got minimum free students and atmost one NRI studentd) Display the student who got second maximum rank admission detailse) Display the students category wise admission detailsf) Write a plsql routine to check a perfect square number is the given number.
Write a query in SQL code for: "List the book categories and the average book price of each category." Tablename is "BOOKS" and column names are: ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY
Write an appropriate SQL query to determine which modules have the same number of credits.
Write a SQL query to retrieve the First_name of employees having any of the following SSN_NUMBER 123456789, 987654321. Attribute Data Type Constraint First Name Varchar(15) Not Null Last Name Varchar(15) Not Null SSN Number Char(9) Primary Key
Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE_DATE SALARY DEPARTMENT Juniad@abc.com | 2010-06-18 Irfan@abc.com Hassan@abc.com 2010-03-08 Fahad@abc.com 2013-01-28 110000.00 CS 100000.00 Sales 88000.00 Marketing 101 Juniad Irfan 102 2011-04-16 103 Hassan 104 Fahad 90000.00 Sales 105 Husnain Hus@abc.com 2012-01-28 55000.00 ES 1. Write a query to display sales and marketing department data. 2. Write a query to get the names, salary, PF of all the employees (PF is calculated as 15% of salary). 3. Write a query to get the total salaries payable to employees. 4. Write a query to get the average salary and number of employees in the employees table. 5. Write a query to select first 2 records from a table. 6. Write a query to get the name of employees ends with character 'N'. Such as Hassan etc.
Write an sql query to find the maximum, minimum, and average salary of the employees
Write down a sql query to find out "Firstname" (s) those have "s" letter in it and havemonthly salary not more than 50000k