Based on the three tables and the attributes below, write SQL commands for each question to retrieve the data from the database. Inventory Y InventoryID Name BeverageType Caffeinated Flavored Purchase Price Required A ∞ Required B SELECT FROM WHERE GROUP BY SalesItems InvoicelD InventoryID Quantity UnitPrice Complete this question by entering your answers in the tabs below. Sales Required: a. What are the foreign keys in the Sales table? b. How many sales transactions were made in March, 2017? c. Which sales transactions were made by the employee whose ID is 'S2038' in the system? d. List the inventory items with purchase price larger than $6,500. e. Write a query to find out the dollar amount of each sales transaction. ∞ Write a query to find out the dollar amount of each sales transaction. 1 Required C Required D Required. E InvoicelD InvoicelD Sales InvoicelD SUM ([Quantity]* Salesitems InvoiceID InvoiceDate OrderDate CustomerID EmployeeID CustomerPO UnitPrice SalesItems 1) AS Amount InvoiceID

Based on the three tables and the attributes below, write SQL commands for each question to retrieve the data from the database. Inventory Y InventoryID Name BeverageType Caffeinated Flavored Purchase Price Required A ∞ Required B SELECT FROM WHERE GROUP BY SalesItems InvoicelD InventoryID Quantity UnitPrice Complete this question by entering your answers in the tabs below. Sales Required: a. What are the foreign keys in the Sales table? b. How many sales transactions were made in March, 2017? c. Which sales transactions were made by the employee whose ID is 'S2038' in the system? d. List the inventory items with purchase price larger than $6,500. e. Write a query to find out the dollar amount of each sales transaction. ∞ Write a query to find out the dollar amount of each sales transaction. 1 Required C Required D Required. E InvoicelD InvoicelD Sales InvoicelD SUM ([Quantity]* Salesitems InvoiceID InvoiceDate OrderDate CustomerID EmployeeID CustomerPO UnitPrice SalesItems 1) AS Amount InvoiceID

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

I need help with this SQL query: Write a MySQL statement to create a table named jobs including columns job_id, job_title, min_salary and max_salary, and check whether the min_salary amount is lower than the lower limit $15,000 and whether the max_salary amount exceeds the upper limit $50,000.
Q. Please write SQL codes to query data from member tables based on below criteria Please write a SELECT statement to display each member’sdata that member_id is an odd number. Please display the result in ascending order of the last_name. The result should be identical to below results: [Screenshot]
The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all movies. Press the Run button to produce a result table. Verify the result table displays five movies. Modify the SELECT statement to only select movies released after October 31, 2015: SELECT*FROM Movie WHERE ReleaseDate >'2015-10-31'; Then run the SQL again and verify the new query returns only three movies, all with release dates after October 31, 2015. CREATE TABLE Movie ( ID INT, Title VARCHAR(100), Rating VARCHAR(5), ReleaseDate DATE); INSERT INTO Movie VALUES (1, 'Rogue One: A Star Wars Story', 'PG-13', '2016-12-10'), (2, 'Hidden Figures', 'PG', '2017-01-06'), (3, 'Toy Story', 'G', '1995-11-22'), (4, 'Avengers: Endgame', 'PG-13', '2019-04-26'), (5, 'The Godfather', 'R', '1972-03-14'); -- Modify the SELECT statement:SELECT *FROM Movie;Where ReleaseDate > '2015-10-31';
What variables should be taken into account when determining whether or not to establish an index for a column in SQL.
code of create table and insert table only please
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)…
Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 SQL Database Add the four maintenance types to the MAINTENANCE_TYPES table Test Query SELECT * FROM MAINTENANCE_TYPES Expected Results MAINTENANCE_TYPE_ID MAINTENANCE_TYPE_DESCRIPTION MAINTENANCE_PRICE 1 Tire Change 50 2 Oil Change 45 3 Full Cleaning 100 4 Gas Pump Change 145
using the link below, select which data type best fits the following needs: https://www.w3schools.com/sql/sql_datatypes.asp The Date a student enrolls with a university The students phone number The name of a degree program The students financial aid amount
Given the table PRODUCT(ProductID, ProductName, ProductClass, ProductWeight, ProductStyle, ProductColor, ProductPrice). Note: ProductWeight and ProductPrice are numeric fields, and the other attributes are character fields, i.e., store text. Write a SQL query to display the product class whose average price is at least 50
Based on the following tables, write appropriate SQL statements to carry out the following tasks: CLIENT CLIENT_NAME LOCATION SAM LEE MELAKA LEE MEI TENG PENANG ΚΙΚΟ ΤΑΝ KL ADAM ALI KL EVA KUMAR MELAKA SALESPERSON SALES_NAME POSITION AREA JAMES ANG JUNIOR MELAKA MARCUS TEO SENIOR PENANG LILY TAY JUNIOR KL (a) Add the following record into the SALESPERSON table. SALES_NAME POSITION AREA JOYCE SENIOR MELAKA (b) Show how all junior salesperson can be removed from SALESPERSON. (c) Change Lily's position as she has been promoted from junior to senior level. (d) Retrieve all clients who are located in Melaka. Sort the result in ascending order by location. (e) Display the number of clients in each location. (f) Display those clients with the surname “Lee". (g) List the salesperson name and position for all senior salesperson from Penang. (h) List the salesperson and client names who are located in the same area.
Please help with pl/sql block!
Please help with the following: Using oracle sql live or sql developer what sql statements could be use to find the following: A simple database composed of the following tables: PATIENT, DOCTOR, DRUG, and PRESCRIPTION. Please explore the database and then write the appropriate SQL command. List all the rows in which the prescription dates occur on or after November 14. List all drugs with their expiration date (one year from the date of manufacturer) sql doc below Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End;//* */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR VALUES('29827','Sanchez','Julio','J','Dermatology');INSERT INTO DOCTOR VALUES('32445','Jorgensen','Annelise','G','Neurology');INSERT INTO DOCTOR…