Which clause do you add to the following SELECT statement to limit the display to those categories that their total price is out of the range 5000 to 7000 (We also do not want to include 5000 and 7000 in the result)? SELECT catergoty_id, SUM(price) FROM products GROUP BY catergoty_id O a. HAVING SUM(price) < 5000 or SUM(price) > 7000 O b. HAVING SUM(price) > 5000 and SUM(price) < 7000 O. WHERE SUM(price) < 5000 or SUM(price) > 7000 O d. WHERE SUM(price) > 5000 and SUM(price) < 7000

Which clause do you add to the following SELECT statement to limit the display to those categories that their total price is out of the range 5000 to 7000 (We also do not want to include 5000 and 7000 in the result)? SELECT catergoty_id, SUM(price) FROM products GROUP BY catergoty_id O a. HAVING SUM(price) < 5000 or SUM(price) > 7000 O b. HAVING SUM(price) > 5000 and SUM(price) < 7000 O. WHERE SUM(price) < 5000 or SUM(price) > 7000 O d. WHERE SUM(price) > 5000 and SUM(price) < 7000

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

Task 3: StayWell is offering a monthly discount for residents who pay their rent on a quarterly basis. The discount is 1.75 percent of the monthly fee. For each property, list the office number, address, owner number, owner’s last name, monthly rent, and discount as DISCOUNT. The discount should be rounded to the nearest dollar.
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
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?
Q1. Please write a query statement from emp table to display ename, sal, and sal_star for all employees. Each astetrisk is signified by a one-hundred dollars. For example, Mary's sal is 1500, the sal_star data is 3 asterisks. Sort the data in an descending order of sal_star. Label the column headingto ENAME and SAL_STAR. The result should be like below: [image below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing
Use select statements to create queries that answer the following questions. Only provide the information requested. Do not provide the output. All tables are provided below List the name of all bouquets that are priced at $29.99. List the customer id for all customers who ordered item 7.
In the BOOK_PRICING table, you should indicate that the Category field is not being utilized. Confirm that the column is no longer an option to choose.
The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL_ID count to the three mathematical functions.
Modify the SELECT statement to select the title and release date of PG-13 movies that are released after February 1, 2008. Run your solution and verify the result table shows just the titles and release dates for The Dark Knight and Crazy Rich Asians. CREATE TABLE Movie ( ID INT AUTO_INCREMENT, Title VARCHAR(100), Rating CHAR(5) CHECK (Rating IN ('G', 'PG', 'PG-13', 'R')), ReleaseDate DATE, PRIMARY KEY (ID)); INSERT INTO Movie (Title, Rating, ReleaseDate) VALUES ('Casablanca', 'PG', '1943-01-23'), ('Bridget Jones\'s Diary', 'PG-13', '2001-04-13'), ('The Dark Knight', 'PG-13', '2008-07-18'), ('Hidden Figures', 'PG', '2017-01-06'), ('Toy Story', 'G', '1995-11-22'), ('Rocky', 'PG', '1976-11-21'), ('Crazy Rich Asians', 'PG-13', '2018-08-15'); -- Modify the SELECT statement:SELECT *FROM MovieWHERE ReleaseDate < '2000-01-01';
Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
The APPT_DTTM column stores the date and time of an appointment. Which of the following expressions would return TRUE for all appointments on January 1, 2018, and FALSE for all other appointments? SELECT ONE OF THE FOLLOWING A. APPT_DTTM >= '1 JAN 2018' AND APPT_DTTM < '2 JAN 2018' B. APPT_DTTM = '1 JAN 2018' C. APPT_DTTM > '31 DEC 2017' AND APPT_DTTM <= '1 JAN 2018' D. APPT_DTTM > '31 DEC 2017' AND APPT_DTTM < '2 JAN 2018' Choose one correct answer and what is output of remaining queries with proper explanation
Which result set requires a JOIN? Showing all album titles with both artist ID and album ID Showing artist names with artist_id's Showing artist_id with album title Showing all album_id's with artist names