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 2 Write the SQL query to get the employee number, last name, first name, employee's office country location, who they report to (boss-employee number), boss last name, boss first 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. HINT: You may need to reference the tables twice.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!