1. Prepare a list of orders by Shipper showing the Shipper ID, Order ID, Product ID and Quantity. List shoul be in shipper orders 1. Prepare a list of orders by employee showing the employee ID, Order ID, Product ID and Quantity. List should be in employee order 1. Prepare a list of orders by customers showing the customer ID, Order ID, Product ID and order quantity. List should be in customer order Please give SQL Statements

1. Prepare a list of orders by Shipper showing the Shipper ID, Order ID, Product ID and Quantity. List shoul be in shipper orders 1. Prepare a list of orders by employee showing the employee ID, Order ID, Product ID and Quantity. List should be in employee order 1. Prepare a list of orders by customers showing the customer ID, Order ID, Product ID and order quantity. List should be in customer order Please give SQL Statements

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

3. Determine the amount of total profit generated by the book purchased on order 1002.Display the book title and profit. The profit should be formatted to display a dollar sign andtwo decimal places. Take into account that the customer might not pay the full retail price,and each item ordered can involve multiple copies. SQL commands
T-SQL procedure A: obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM. Place these valuse in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. Output the content of I_CUSTOMER_NAME and I_CREDIT_LIMIT. B: obtain the order date, customer number and name for the order whose number currently is stored in I_ORDER_NUM. place these values in the variables I_ORDER_DATE, I_CUSTOMER_NUM and I_CUSTOMER_NAME , respectively. output the contents of I_ORDER_DATE, I_CUSTOMER_NUM , and I_CUSTOMER_NAME. C: add a row to the ORDERS table. D: change the date of the whole number is stored in I_ORDER_DATE to the date currently found in I_ORDER_DATE. E: delete the order whose number is stored in I_ORDER_NUM.
Create a function to determine the total pledge amount for a project. Use the function in an SQL statement to list all projects, displaying project ID, project name, and project pledge total amount. Format the pledge total amount to show a dollar sign. programming language - sql
5. Determine which author or authors wrote the books most frequently purchased bycustomers of JustLee Books. SQL commands
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.
ISBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write the PL/SQL code to create a procedure that accepts a product price and increases it by 10%
Database Q1: Select the correct SQL statement to provide the user Samer with read only permission on Employees table a) Grant read on Employee where username = Samer; b) Grant read only on Employee to Samer; c) Grant select to Samer on Employee; d) Grant select on Employee to Samer; Q2: Based on the TWO schema structures below, which SQL statement will create a view to show department names where each department has at least 5 employees? Employee (E_ID, E_Name, D_ID, E_Salary) Department (D_ID, D_Name, D_Address) (Select one) a) Create View Dept_Emp as select D_Name, count(E_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Where count (E_ID) >= 5; b) Create View Dept_Emp as select D_Name, count(E_ID) from Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; c) Create View Dept_Emp as select D_Name, count(D_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; d)…
5. Display the employee name and department number of all employees in departments 10 and 30 in alphabetical order by name. ENAME DEPTNO ALLEN 30 BLAKE 30 CLARK 10 30 10 30 JAMES KING MARTIN MILLER 10 TURNER 30 WARD 30 9 rows selected 6. Modify p2q3.sql to list the name and salary of employees who earn more than $1500 and are in department 10 or 30. Label the columns Employee and Monthly Salary, respectively. Resave your SQL statement to a file named p2q6.sql Rerun your query. Employee Monthly Salary KING 5000 BLAKE 2850 CLARK 2450 ALLEN 1600
IN SQL If you omitted the WHERE clause of SELECT statement, the query returns an error because the where clause is required. Select one: True False
Database Oracle sql Note :I hope the solution is from HR in the Oracle sql software
8. Using today’s date, determine the age (in months) of each book that JustLee sells. Makesure only whole months are displayed; ignore any portions of months. Display the book title,publication date, current date, and age. SQL commands
in sql The ALTER SEQUENCE statement can be used to: Select one: a. Change the maximum value to a lower number than was last used b. Change the name of the sequence c. Change the START WITH value of a sequence d. Change the amount a sequence increments each time a number is generated