Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Correct and detailed answer will be Upvoted else downvoted.
GNF
WEEK 9 ASSIGNMENT#6
Part II:
Complete the following exercise:
Using a subquery, select student first name where the student is in the student course table.
Using a subquery, select the course id where the average GPA is 2.
Using a subquery, select the course id where the average GPA is greater than 2.
Using a subquery, select student first name where the student is not in the student course t
Assemble all information necessary to create an invoice for order number 1006.
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Rename the EMPLOYEES table as JL_EMPS.arrow_forwardTask 2: For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name, and last name of the customer for which the invoice was created.arrow_forwardTask 6: Find the ID, first name, and last name of each customer for which an invoice was not created on November 15, 2021. Task 13: List the invoice number and invoice date for each invoice created for the customer James Gonzalez. Task 15: List the invoice number and invoice date for each invoice that either was created for James Gonzalez or that contains an invoice line for Wild Bird Food (25lb). TEMPLATE -- Task # 6SELECT CUSTOMER.CUST_ID, FIRST_NAME, LAST_NAMEFROM _____________, _________________WHERE CUSTOMER.________________ = ______________.CUST_IDAND INVOICES.____________________ <> '2021-11-15'; -- Task # 13SELECT INVOICE_NUM, INVOICE_DATEFROM ______________WHERE ____________ IN (SELECT CUST_ID FROM CUSTOMER WHERE _____________ = _______________AND ____________ = ______________); -- Task # 15SELECT DISTINCT INVOICES.INVOICE_NUM, INVOICES.INVOICE_DATEFROM INVOICES, INVOICE_LINE, ITEM, CUSTOMERWHERE INVOICES.INVOICE_NUM = INVOICE_LINE.INVOICE_NUMAND INVOICE_LINE.ITEM_ID =…arrow_forward
- Table EMP Column name Column type Integer Up to 10 characters Example entry EMPNO ENAME Description Employee ID number Employee surname 7369 SMITH Integer Integer Employee's job title No ID no. of employee's JOBNO 10 MGR 7566 manager HIREDATE Date 17/12/1980 Date employment started Monthly salary SAL Integer 1600 Table JOB Column name Column type Integer Up to 15 characters Example entry Description job title No Employee's job title JOBNO 10 JOB TITLE SALESMAN a) Write SQL statements to create EMP and JOB tables. Define appropriate data types and check constraints for the tables' fields. Write SQL statements to populate these tables with 3 rows of sample data.arrow_forward1- List all the users and their card name using union2- List all the users and their card name using Intersection 3- List all the card numbers with owner names and scheduled transactions, in case the user hasnever used scheduled transaction show null or zero in the transaction column. (Hint use ISNULLfunction)arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L