please use sql to answer the following question an erd has been adding to to question question t ORDERSOrder#Customer#OrderdateShipdateShipstreetShipcityShipstateShipzipShipcostCUSTOMERSCustomer#LastnameFirstnameEmailAddressCityStateZipReferredRegionBOOKAUTHOR AUTHORВОOKSAuthorDISBNISBNAuthorIDLnameFnameORDERITEMSTitlePubdatePubIDCostRetallDiscountCategoryOrder#Item#ISBNQuantityPaideachPUBLISHERPubIDNamePROMOTION ContactGiftMinretailMaxretallPhoneFIGURE 1-5JustLee Books's table structures after normalization To perform below tasks, refer to tables in the JustLee Book databaseeJoinse8. .Identify the authors of the books Becca Nelson ordered. Perform the searchusing theecustomer name.eUsing Single Row Functions (INSTR, LENGTH , SUBSTR etc)-9. Produce a list of each customer number and the third and fourth digits of his orher zip code. The query should also display the position of the first occurrence ofa 3 in the customer number, if it exists.eGroup By / Subquery10. What's the retail price of the most expensive book written by Lisa White?

As per our guidelines we are supposed to answer?️ only one question. Kindly repost other questions…

Answered: 8. .Identify the authors of the books…

Engineering

Computer Engineering

8. .Identify the authors of the books Becca Nelson ordered. Perform the search using thee customer name.e

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Q: nt database. The primary keys are highlighted in bold. Student (studNo, studName, address,…

A: Below is part of a Student database. The primary keys are highlighted in bold. Student (studNo,…

Q: In SQL, which command is used to SELECT only one copy of each set of duplicable rows

A: In SQL command which is used to SELECT only one copy of each set of duplicable rows are:-

Q: g Make sure to use oracle sql command and add foreign keys The faculty and students (we refer to…

A: The given requirements are related to the creation of data model using details provided for the…

Q: In SQL, what numeric data formats are available?

A: Tip Numeric data types are used to store numbers in database tables. Typically, these data formats…

Q: Explain when you would prefer to use embedded SQL over SQL or a general-purpose programming…

A: Embedded SQL is a technique that allows SQL statements to be integrated directly into a…

Q: How do you sort the results of a Select query in SQL?

A: Sorting the results of a Select query in SQL: SQL uses the ORDER BY clause with its SELECT statement…

Q: help with sql class 2 questions 1. Report the names of all authors and the title_name of the…

A: Let's see the answer:

Q: plz help with the following use oracle sql or sql live The procedure should satisfy the following…

A: Answer is given below .

Q: 1- Give an example of the following below in PL/SQL, and briefly describe the purpose of each. a)…

A: ( A ). Procedure :- A Procedure in PL/SQL is a subprogram unit that comprises of a gathering of…

Q: The following SQL clause(s) are not permitted to be used in a subquery in the WHERE or HAVING…

A: Multicolumn subqueries cannot use the <, >, <=, >= comparison operators.

Q: Below is part of a Student database. The primary keys are highlighted in bold. Student (studNo,…

A: Given to write a PL/SQL PROCEDURE that will list the project names given the course ID. The below…

Q: Complete PL/SQL function below, which will return last name of employee whose id is equals to 2…

A: The above question is solved in step 2:-

Q: In SQL, what statement do you use to retrieve specific rows from a table in a database?

A: SELECT: The "SELECT" statement is been used for selecting rows from a database. All the fields…

Q: The faculty and students (we refer to them in our system as clients) can electronically check out…

A: ANS 1. The ERD has 3 entity which are : book, client, author. -- The ERD and Relational is given…

Question

please use sql to answer the following question an erd has been adding to to question question t

ORDERS
Order#
Customer#
Orderdate
Shipdate
Shipstreet
Shipcity
Shipstate
Shipzip
Shipcost
CUSTOMERS
Customer#
Lastname
Firstname
Email
Address
City
State
Zip
Referred
Region
BOOKAUTHOR AUTHOR
ВОOKS
AuthorD
ISBN
ISBN
AuthorID
Lname
Fname
ORDERITEMS
Title
Pubdate
PubID
Cost
Retall
Discount
Category
Order#
Item#
ISBN
Quantity
Paideach
PUBLISHER
PubID
Name
PROMOTION Contact
Gift
Minretail
Maxretall
Phone
FIGURE 1-5
JustLee Books's table structures after normalization

To perform below tasks, refer to tables in the JustLee Book databasee
Joinse
8. .Identify the authors of the books Becca Nelson ordered. Perform the search
using thee
customer name.e
Using Single Row Functions (INSTR, LENGTH , SUBSTR etc)-
9. Produce a list of each customer number and the third and fourth digits of his or
her zip code. The query should also display the position of the first occurrence of
a 3 in the customer number, if it exists.e
Group By / Subquery
10. What's the retail price of the most expensive book written by Lisa White?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1 Explaination

VIEW

Step 2 SQL query for 8

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

SQL Statement: SELECT FROM Shippers; Edit the SQL Statement, and click "Run SQL" to see the result. Show Transcribed Text Get your own SQL server Your Database: Tablenames Records Customers Categories Employees OrderDetails Orders Products Shippers Suppliers 91 8 10 518 196 77 3 29 1. Prepare a list of orders by Shipper showing the Shipper ID, Order ID, Product ID and Quantity. List should be in shipper orders 1. Prepare a list of orders by employee showing the employee ID, Order ID, Product ID and Quantity. List should be in employee order 1. Prepare a list of orders by customers showing the customer ID, Order ID, Product ID and order quantity. List should be in customer order Please give SQL Statements
How does the PARSE function differ from the TRY_PARSE function in SQL when converting data types?
student(sid, sname, sex, age, year, gpa) dept(dname, numphds) prof(pname, dname) course(cno, cname, dname) major(dname, sid) section(dname, cno, sectno, pname) enroll(sid, grade, dname, cno, sectno) Write the following SQL queries for the schema above: Print the course names, course numbers and section numbers of all classes with less than six students enrolled in them. Print the name(s) and sid(s) of the student(s) enrolled in the most classes. Print the names of departments that have one or more majors who are under 18 years old. Print the names and majors of students who are taking one of the College Geometry courses. For those departments that have no majors taking a College Geometry course, print the department name and the number of PhD students in the department. Print the names of students who are taking both a Computer Sciences course and a Mathematics course. For each department that has one or more majors with a GPA under 1.0, print the name of the…
Please help with the following: Using oracle sql live or sql developer what sql statements could be use to find the following: A simple database composed of the following tables: PATIENT, DOCTOR, DRUG, and PRESCRIPTION, is now loaded with this assignment and you are ready to start. Please explore the database and then write the appropriate SQL command. List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order sql doc below Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End;//* */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR VALUES('29827','Sanchez','Julio','J','Dermatology');INSERT INTO DOCTOR…
QUICK SQL REQUEST (beginner level...) Back at work on Monday morning, the Vice President of Purchasing asks you to help him with the analysis of in-process storage. He asks you to pull information regarding the number of products per storage location. The result of the query should show: - The name of the warehouse (Location) - The number of different products per storage location - The total quantity of products found at this storage location - The average price of all products found at this storage location He mentions that for the moment he is only interested in the locations that have more than 50 distinct products because he wants to start inventorying the biggest locations first. Show the locations in order of smallest to largest number of distinct products. My request is linked to the question but i'm having trouble executing it I would love to know how to do it, thanks in advance.
ISBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write the PL/SQL code to create a procedure that accepts a product price and increases it by 10%
using the link below, select which data type best fits the following needs: https://www.w3schools.com/sql/sql_datatypes.asp The Date a student enrolls with a university The students phone number The name of a degree program The students financial aid amount
SQL Database Designs What do you think is the most important concept in SQL Database Designs
Please help with the following: Using oracle sql live or sql developer what sql statements could be use to find the following: A simple database composed of the following tables: PATIENT, DOCTOR, DRUG, and PRESCRIPTION. Please explore the database and then write the appropriate SQL command. List doctor’s details where speciality is either Dermatology or Neurology. (Use INoperator). List the results by the first name in ascending order and the last name indescending order. Find all patients rows whose first names include ‘George’ (Assume case sensitivity). sql doc below Beginfor c in (select table_name from user_tables) loopexecute immediate ('drop table '||c.table_name||' cascade constraints');end loop;End;//* */ ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY';CREATE TABLE DOCTOR (DOC_ID varchar2(5) PRIMARY KEY,DOC_LNAME varchar2(15),DOC_FNAME varchar2(15),DOC_INITIAL varchar2(1),DOC_SPECIALTY varchar2(15));INSERT INTO DOCTOR…
What are some common uses for the STRING_AGG function in SQL?
in SQL Code: Explain the difference between number and binary integer and how it is used? Please provide a code example
Branch Table BranchNo Name B001 Location 567, Kileleshwa 890, Karen 894, Rongai Kileleshwa BO02 Karen ВООЗ Rongai i). Write appropriate SQL statement to display all staff who work at BranchNo "BO02"