- Consider The Following Database Diagram For All The Sql Query Questions The Following Diagram Is A Slightly Modified Ve 1 (119.16 KiB) Viewed 258 times
part two
SQL Query 2
write the SQL query to get the employee number, last name, first
name, employees office country location, who they report to
(boss-employee number), boss last name, boss forst name, and
country where the boss office is located. show the rows where the
country of the offices of the employee and the boss are
different
- Consider The Following Database Diagram For All The Sql Query Questions The Following Diagram Is A Slightly Modified Ve 2 (22.01 KiB) Viewed 258 times
Consider the following database diagram for all the SQL Query questions. The following diagram is a slightly modified version of the sample database of MySQL server. MYSQL Sample Database Diagram productlines product line textDescription bilmiDescription image products product Code productName productline productScale product vendor productDescription quantity Sock buyPrice MSRP orderdetails order Number product Code quantyOrdered priceEach orderline Number ee employees employeeNumber las Name FirstName Tin englon ora office Code reports To abide orders ordel Number orderdale required to shipped status comments customer Number ex offices glice Code dly phone addressLine1 addressLine2 store Country postalCode territory customers HoustomerNumber customer Name contact.astName contactFirstName phone addressin addressLine2 oty state postal Code country Sales Repemployee Number creditimi payments customerNumber checkNumber paymentData amount In this diagram, the primary keys are shown with an asterisk (*) and foreign keys have the same name in most of the cases. Additionally, for running queries purposes only, you can download the database for SQLite by right clicking and saving link as from the following link (
https://cs.usa.edu/cs1083/MySQL SampleOdb). SQL Query 1 Write the sol query to get all the information of the French customers with a credit limit between 75,000 and 100,000, values included.
SQL Query 3 Write the SQL query to get the order number, order date, customer name, shipped date, and sales representative employee number of the orders with status "cancelled" of the product line "Planes" and the quantity ordered was between 30 and 40, excluding the 30 and 40 values.