You work in Marketing and are planning a sales campaign for household products and wish to know details about select products and their sales history. Develop a query that includes these attributes in this order: product name, product unit price, product units in stock, and an aggregate column that represents the total quantity sold on all past sales, named "Historic Product Sale Quantity." Restrict the query output in this order: records that include product names that end with the pattern "lamp" or "quilt" or that include the pattern "clock" or "carpet" anywhere within the product name. Sort the output by the "Historic Product Sale Quantity" and then the product name. SQL Statement (case sensitive, must reflect what was used in SQL Browser to execute the prompt): SELECT Product.ProdName, Product.UnitPrice, Product.UnitslnStock, QtySold) AS "Historic Product Sale Quantity" FROM Product JOIN ON Product.ProdID= .ProdID WHERE Product.ProdName %3D Product.ProdName Product.ProdName Product.ProdName GROUP BY Product.ProdName, Product.UnitPrice, Product.UnitslnStock ORDER BY "Historic Product Sale Quantity", Product.ProdName; Query Result Count (enter number only, ex. 12): Result: rows

You work in Marketing and are planning a sales campaign for household products and wish to know details about select products and their sales history. Develop a query that includes these attributes in this order: product name, product unit price, product units in stock, and an aggregate column that represents the total quantity sold on all past sales, named "Historic Product Sale Quantity." Restrict the query output in this order: records that include product names that end with the pattern "lamp" or "quilt" or that include the pattern "clock" or "carpet" anywhere within the product name. Sort the output by the "Historic Product Sale Quantity" and then the product name. SQL Statement (case sensitive, must reflect what was used in SQL Browser to execute the prompt): SELECT Product.ProdName, Product.UnitPrice, Product.UnitslnStock, QtySold) AS "Historic Product Sale Quantity" FROM Product JOIN ON Product.ProdID= .ProdID WHERE Product.ProdName %3D Product.ProdName Product.ProdName Product.ProdName GROUP BY Product.ProdName, Product.UnitPrice, Product.UnitslnStock ORDER BY "Historic Product Sale Quantity", Product.ProdName; Query Result Count (enter number only, ex. 12): Result: rows

A Guide to SQL

9th Edition

ISBN:9781111527273

Author:Philip J. Pratt

Publisher:Philip J. Pratt

Chapter8: Sql Functions And Procedures

Section: Chapter Questions

Problem 9CAT

See similar textbooks

Similar questions

Create a query that will show the person id and fee for all players in the football database. Additionally create a column in your output to show the amount of increase if the fee were increased by 20%. Also produce a column that will show what the new fee would be with the 20%. Sort your results showing those that do not pay a fee at the bottom of your list. Finally make sure your column headings read: Person ID, Current Fee, Increase and New Fee. Make sure your spelling and case EXACTLY match what is specified.
INSTRUCTIONI have posted below the EER model you need to use while answering the question below. QUESTION 4. Create the following FOUR queries: Create a query that lists all patients who have not had any appointment in the clinic in the last 2 years (at least one patient) Create a query that returns the all appointment by a particular patient in the year of 2020 (should return 5 appointments at least) the result set would include patient names, examining doctors’ and nurses’ names, dates and times of the appointments, any tests ordered by the doctors for the Create a query that returns all appointments that were either cancelled, or patients were No Show in the month of December 2020. (five results minimum) Create a query that returns staff members’ names (excluding doctors), their hourly rates, number of hours worked, and Salary (calculated column; there are 13 employees in the clinic) for the two weeks period (
Go ahead and run the below query into your "users" table. You just need to copy and paste it. 2- write a query to select all data with "mypass" password (first_name, last_name, email, pass, registration_date) VALUES ('Larry', 'Ullman', 'email@example.com', SHA1('mypass'), NOW());INSERT INTO users VALUES (NULL, 'Zoe', 'Isabella', 'email2@example.com', SHA1('mojito'), NOW());INSERT INTO users (first_name, last_name, email, pass, registration_date) VALUES('John', 'Lennon', 'john@beatles.com', SHA1('Happin3ss'), NOW()),('Paul', 'McCartney', 'paul@beatles.com', SHA1('letITbe'), NOW()),('George', 'Harrison', 'george@beatles.com ', SHA1('something'), NOW()),('Ringo', 'Starr', 'ringo@beatles.com', SHA1('thisboy'), NOW());INSERT INTO users (first_name, last_name, email, pass, registration_date) VALUES('David', 'Jones', 'davey@monkees.com', SHA1('fasfd'), NOW()),('Peter', 'Tork', 'peter@monkees.com', SHA1('warw'), NOW()),('Micky', 'Dolenz', 'micky@monkees.com ', SHA1('afsa'), NOW()),('Mike',…
what is wrong with this query: Select Title,count(Rental_ID) as Rentals,(rental_rate*Count(rental_id)) As RevenueFrom Film join Inventory on Film.Film_ID = Inventory.Film_ID join rentalGroup By TitleOrder By Revenue Desc
Create a query that returns the all appointment by a particular patient inthe year of 2020 (should return 5 appointments at least) the result setwould include patient names, examining doctors’ and nurses’ names,dates and times of the appointments, any tests ordered by the doctorsfor the patient.
using sql develpper or sql live oralce Create the DONORS table with the following columns: donor_id ( PRIMARY KEY), donor_name (Not Null), donor_age. Then Create DONATIONS table with the following columns: pledge_id (PRIMARY KEY), pledge_date, amount_pledged, amount_paid, Is_paid, donor_id that REFERENCES to DONORS table (donor_id). 2- Populate every relation with three rows. 3- Now, your supervisor has asked you to modify the donor_age column in the DONORS table. He wants the column to be configured to accept a value that must be >=20. Which statement should you issue to accomplish this task? 4- Create a Trigger to update Is_paid column to 1 when the amount_paid equal to amount_pledged.
PLz help with the following Please implement the following using Oracle live/SQL Developer: 1- Create the DONORS table with the following columns: donor_id ( PRIMARY KEY), donor_name (Not Null), donor_age. Then Create DONATIONS table with the following columns: pledge_id (PRIMARY KEY), pledge_date, amount_pledged, amount_paid, Is_paid, donor_id that REFERENCES to DONORS table (donor_id). 2- Populate every relation with three rows. 3- Now, your supervisor has asked you to modify the donor_age column in the DONORS table. He wants the column to be configured to accept a value that must be >=20. Which statement should you issue to accomplish this task? 4- Create a Trigger to update Is_paid column to 1 when the amount_paid equal to amount_pledged.
university maintains data on professors, departments, courses, and schedules in fourDEPARTMENT, PROFESSOR, COURSE, and SCHEDULE.Write a query to print the names of professors with the names of the courses they teaclhave taught) outside of their department. Each row in the results must be distinct (i.e., aprofessor teaching the same course over multiple semesters should only appear once),the results can be in any order. Output should contain two columns: PROFESSOR.NAMLCOURSE.NAME.lol
Task 3: Create(Enter) new product by using a Procedure with IN ParametersFollow these steps to create a procedure that allows a company employee to add a new product to the database. This procedure needs only IN parameters. In SQL Developer, create a procedure named PROD_ADD_SP that adds a row for a new product in the BB_PRODUCT table. Keep in mind that the user provides values for the product name, description, image filename (use same template for file name as ‘roasted.jpg’ or ‘double-roasted.jpg’ ) , price, and active status. Address the input values or parameters in the same order as in the preceding sentence. Call the procedure with these parameter values: ('Roasted Blend', 'Well-balanced mix of roasted beans, a medium body', 'roasted.jpg',9.50,1). Check whether the update was successful by querying the BB_PRODUCT table. -This will be a page where you allow new product information to be entered into Edit box by end user and then there will be INSERT or ADD Product button to…
From vendors table, write a query to retrieve records as follows: On the first column, add vendorcontact first name, a space, and vendor contact last name. Name the first column “Vendor ContactFull Name”. On the second column, retrieve the total number of characters of the “Vendor ContactFull Name” column. Do NOT count the space in between first name and last name. Name thesecond column “Full Name Length”.The two columns should look like this:Vendor Contact Full Name Full Name LengthJinsoo Yeo 9Hint1: CONCAT and CHAR_LENGTH functions might be useful!Hint2: the number of characters for Francesco Alberto is 16.
Build on the query you used in the prior line to get these columns from FINANCIAL REPORTING: account, business_unit, currency, reporting_year, scenario, jan + feb + mar apply a filter where jan + feb + mar is less than -89,854,079 and reporting year is less than 2021. Please make a screenshot of your SQL and the output and save as screen2.jpg Below is sample output. Use to give you an idea of structure of output: Page 5 of 2
Please help and break down all the steps I should take in order to succesfully complete the query. Create the following query in access: a. The company has been informed that the tax has been increased to 17.5%. Calculatehow much additional tax (i.e., the difference) the store would have collected by year.Name this query Q3 – ADDED-TAX.

SEE MORE QUESTIONS

Recommended textbooks for you

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science