4. Write a SQL query to find all the invoices for customer 56 and 58 where the total was between $1.00 and $5.00. 5. Write a SQL query to find all the tracks whose name starts with 'All'. 6. Write a SQL query to find all the customer emails that start with "J" and are from gmail.com. 7. Write a SQL query to find all the invoices from the billing city Brasília, Edmonton, and Vancouver and sort in descending order by invoice ID. 8. Write a SQL query to show the number of orders placed by each customer (hint: this is found in the invoices table) and sort the result by the number of orders in descending order. 9. Write a SQL query to find the albums with 12 or more tracks.

4. Write a SQL query to find all the invoices for customer 56 and 58 where the total was between $1.00 and $5.00. 5. Write a SQL query to find all the tracks whose name starts with 'All'. 6. Write a SQL query to find all the customer emails that start with "J" and are from gmail.com. 7. Write a SQL query to find all the invoices from the billing city Brasília, Edmonton, and Vancouver and sort in descending order by invoice ID. 8. Write a SQL query to show the number of orders placed by each customer (hint: this is found in the invoices table) and sort the result by the number of orders in descending order. 9. Write a SQL query to find the albums with 12 or more tracks.

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

In cell K1, enter a formula using the MAXIFS function to find the NO. Participants where the cost is $15 in the city of Atlanta.
Determine which types of books are currently available in the current inventory. Each category should only be included once.
7. What gift will a customer who orders the book Shortest Poems receive? Use the actualbook retail value to determine the gift.
C) Which employees earn less salary than the average salary for the consultants who perform the same job? Show the employees first and last names, job id, salary, department name, and manager's last name. Sort the result by the employees’ employee id. D) For each department, find the manager who pays out the most in salaries. Show the department number, the manager's last name, and the total she/he pays each month. Sort by the department number. Here are the tables and the columns within the table Here are the tables and the columns within the table CONSULTANTS - CONSULTANT_ID- FIRST_NAME- LAST_NAME- EMAIL- PHONE_NUMBER- HIRE_DATE- JOB_ID- SALARY- COMMISSION_PCT- MANAGER_ID- DEPARTMENT_ID . COUNTRIES - COUNTRY_ID- COUNTRY_NAME-REGION_ID . CUSTOMERS - CUST_IDCUST_EMAILCUST_FNAMECUST_LNAMECUST_ADDRESSCUST_CITYCUST_STATE_PROVINCECUST_POSTAL_CODECUST_COUNTRYCUST_PHONECUST_CREDIT_LIMIT . DEPARTMENTS - DEPARTMENT_IDDEPARTMENT_NAMEMANAGER_IDLOCATION_ID . EMPLOYEES -…
What is the name of the columns of thee left hand side of the relationships between columns called?
In a chemistry class there are ten students and each the students has taken 5 tests.The total mark awarded for each test is hundred points.i)With the aid of c++ programming language determine the grade each student got and also the class average. ii)What is the average test score?Determine it. ii)Find the grade using the guide given below. N.b kindly add up the following data in the code(Test scores and students name.) Guide for finding the gradeConsidering the average is >=90 then print grade=A Considering the average is >=80 &&<90 then print grade=B Considering the average is >=70 && average <80 then print grade=C Considering the average is >=60 && average <70 then print grade=D Otherwise print grade=F
Determine the kind of books that are currently available in the library's collection. There should only be one entry in each category.
You will produce a query result set of Products that have a P_PRICE (Price) that is greater than the Average of all the Product's Prices. For instance if there were three products that had a price of (400.00, 300.00, 500.00) then the average would be $400.00. Therefore if you printed it out, there would only be ONE that satisfied the condition of being Greater than the average. In the screen shot below the Average was actually 56.42. Please look at screen output so you can detect how it is sorted by, and which columns you should use. Please use the PRODUCT Table from aboveYour task is to write the SQL to generate the result set below. Hint: You likely will have to use a subquery
The following is a table of applicants to be considered for admission into 07BSAM: POINTS MATH SYMBOL 123 450 NAMES STUDENT NUMBER ENG SYMBOL To qualify for admission, an applicant should have at least 25 points, minimum of B symbol in Mathematics and a minimum of E symbol in English. If an applicant has a C symbol in Mathematics, then the applicant must pass an entrance test to be considered for admission. Hints: There are three modes of study: The Full-time mode, the Part-time mode and the Distance mode. Applicants can choose which mode they want provided there is space in that mode. Each of the Full- time and the Part-time modes cannot accommodate more 30 admitted students. After these two modes are full, every other qualified applicant is admitted in the Distance mode. The admission exercise is first come first served. Write a pseudocode that identifies the applicants that qualify for admission and outputs their names, student numbers and modes of study. Use a FOR-LOOP /…
Apply the INGRES algorithm (the detachment technique) to the following query: Select std_name,std_dpt FROM std_info,std_absence WHERE std_info.std_id%3Dstd_absence.std_id AND std_absence.abs_hrs > 1 AND std_absence.date = '2020-12-06'; std_info I std_id ! std_name ! std_dpt I std_avg ! 1 1 Ahmed 2 I Ali ! Information ! I Networks 75 1 80 : std_absence | std_id : std_name : date I abs_hrs I 1 ! Ahmed 2 I Ali 1 1 Ahmed | 2020-12-06 1 | 2020-12-06 I 2020-12-08 I
Classify students according to the total number of hours they have completed. (Less than30=freshman, 30 to 59 is sophomore, 60 to 89 is junior, 90+ senior)
5. Determine the profit of each book sold to Jake Lucas, using the actual price the customerpaid (not the book’s regular retail price). Sort the results by order date. If more than onebook was ordered, sort the results by profit amount in descending order. Perform thesearch using the customer name, not the customer number.