0% Plagiarism Guaranteed & Custom Written

excluding the RIGHT OUTER JOIN example on the bottom of page 132. Test them in playground.

01 / 10 / 2021 Assignment 2

This paper circulates around the core theme of excluding the RIGHT OUTER JOIN example on the bottom of page 132. Test them in playground. together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.

CS571_Week7_Assignment7.1
For this assignment, be sure to use your playground database to test the queries you write.
2.) Write the same SELECT statement from (1) and additionally add an ORDER BY clause by the last name, then the first name, both in ascending order.
3.) Write the same SELECT statement from (2) and additionally add a WHERE clause that limits the results to only those last names that begin with A or B. (Hint, LIKE is the way to do this; this will give you 26 rows.)
`4.) Write a SELECT statement that returns the following columns from the invoices table: invoice_due_date and invoice_total. Additionally, add a calculation that returns 10% of the value in invoice_total and alias this calculation as initial_payment. (Hints: see the book pages 82-83; 10% of a value is that value times 0.10)5.) Write the same SELECT statement from (4) and additionally add a WHERE clause that limits the results to only those invoices with a total that is greater than or equal to 500 and less than or equal to 1000. (Hint: this will give you 12 rows.)
6.) Write a SELECT statement that returns the following columns from the invoices table: invoice_number and invoice_total. Additionally, add the following two calculations:
Add payment_total to credit_total and alias this as payment_credit_total
invoice_total minus payment_total and credit_total and alias this as balance_due.

7.) Write the same SELECT statement from (6) and additionally add a WHERE clause that limits the results to only those invoices that have a balance due that is greater than $50. (Hint: this will give you 10 rows.)8.) Write the same SELECT statement from (7) and additionally sort the results by the balance due in descending order.9.) Write the same SELECT statement from (8) and additionally limit the results to the results with the 5 largest balances due (Hint: use the LIMIT clause; see pages 108-109.)10.) Write the same SELECT statement from (6) and additionally add the payment_date column to the SELECT clause. Use a WHERE clause that limits the results to only those rows with a NULL value in the payment_date column. (Hint: this will give you 11 rows.)
11.) Write a SELECT statement without a FROM clause that uses the CURRENT_DATE function to return the current date in its default format. (Hint: see pages 88-89.)12.) Write a SELECT statement without a FROM clause that uses the CURRENT_DATE function to return the current date in the mm-dd-yyyy format using DATE_FORMAT. (Hint: see pages 88-89.)CS571_Week7_Assignment7.2
For this assignment, be sure to use your playground database to test the queries you write.
1-6.) Type each of the 6 example queries from the book on the right-hand pages of pages 114-123. Test them in playground. And then, for each, explain in your own English words:
What each query is requesting from the database.
Include descriptions for what ALL of the following SQL keywords are doing in each query they are present in: SELECT, DISTINCT, FROM, WHERE, and ORDER BY
Include a description of how the two tables are being joined together.In all of the following, the common attribute between the two tables will have the same name, so that you know what to join on. Use table aliases.
7.) Write a SELECT from the vendors table INNER JOINed to the invoices table. Return all columns using *. (Hint: this will give you 114 rows.)
8.) Write a SELECT from the invoice_line_items table INNER JOINed to the general_ledger_accounts table. Return all columns using *. (Hint: this will give you 118 rows.)
9.) Write a SELECT from the customers table INNER JOINed to the orders table. Return all columns using *. (Hint: this will give you 46 rows.)10.) Write a SELECT from the employees table INNER JOINed to the departments table. Return all columns using *. (Hint: this will give you 7 rows.)
11.) Write a SELECT from the employees table INNER JOINed to the projects table. Return all columns using *. (Hint: this will give you 7 rows.)
12.) Write a SELECT from the invoices table INNER JOINed to the invoice_line_items table. Return all columns using *. (Hint: this will give you 118 rows.)
13.) Write a SELECT from the order_details table INNER JOINed to the items table. Return all columns using *. (Hint: this will give you 67 rows.)14.) Write a SELECT from the orders table INNER JOINed to the order_details table. Return all columns using *. (Hint: this will give you 67 rows.)15.) Write a SELECT from the invoices table INNER JOINed to the terms table. Return all columns using *. (Hint: this will give you 114 rows.)CS571_Week7_Assignment7.3
For this assignment, be sure to use your playground database to test the queries you write.
1-4.) Type each of the 4 example queries from the book on the right-hand pages of pages 128-133, excluding the RIGHT OUTER JOIN example on the bottom of page 132. Test them in playground. And then, for each, explain in your own English words:
What each query is requesting from the database.
Include descriptions for what ALL of the following SQL keywords are doing in each query they are present in: SELECT, FROM, and ORDER BY
Include a description of how the tables are being joined together.5-7.) Type each of the 3 example queries from the book on the right-hand pages of pages 140-143. Test them in playground. And then, for each, explain in your own English words:
What each query is requesting from the database.
Include descriptions for what ALL of the following SQL keywords are doing in each query they are present in: SELECT, FROM, WHERE, and ORDER BY
Include a description of how the tables are being unioned together.



International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

Company # 11483120

Benefits You Get

  • Free Turnitin Report
  • Unlimited Revisions
  • Installment Plan
  • 24/7 Customer Support
  • Plagiarism Free Guarantee
  • 100% Confidentiality
  • 100% Satisfaction Guarantee
  • 100% Money-Back Guarantee
  • On-Time Delivery Guarantee
FLAT 50% OFF ON EVERY ORDER. Use "FLAT50" as your promo code during checkout