Answer Happy

MySQL Sample Database Diagram productlines productLine textDescription htmlDescription Image products productCode productName og productLine productScale productVendor productDescription quantityInStock buyPrice MSRP orderdetails orderNumber product Code en quantityOrdered priceEach orderlineNumber HT employees employeeNumber lastName FirstName extension email officeCode reports to Job Title orders orderNumber order Date required Date shippedDate status comments customer Number HO ed ed ++ offices officeCode city phone addressLine1 addressLine2 slate country postalCode territory customers customer Number customerName contactLastName contactFirstName phone addressLine1 addressLine2 city state postalCode country salesRepEmployeeNumber creditLimit HH el payments customer Number * checkNumber paymentato amount In this diagram, the primary keys are shown with an asterisk () and foreign keys have the same name in most of t Additionally, for running queries purposes only, you can download the database for SQLite by right clicking and sav SQL Query 1 Write the SQL 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.

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.

SQL Query 4 Write the SQL query to get the customer number, customer name, phone, country, sales representative employee number, first name and last name of the sales representative, and their office's country for those customers that do not have any payment and the office of the sales representative is 'France'.