Use SQL commands. Include both SQL commands and results in your answers. Include screenshots of the SQL results.   KimTay Pet Supplies For each invoice, list the invoice number and invoice date along with the ID, first name, and last name of the customer for which the invoice was created. 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. Use the IN operator to find the ID, first name, and last name of each customer for which as invoice was created on November 15, 2021.

Show the employees who were in the engineering department as of Jan. 1, 2005 (using SQL)

Using SQL: List the title_name and book type of books that have the lowest royalty rate.

Write the SQL code that will produce the results shown as below. Write the SQL code to calculate the ASSIGN_CHARGE values in the ASSIGNMENT table. Note that ASSIGN_CHARGE is a derived attribute that is calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS. Write the SQL code that will yield the total number of hours worked for each employee and the total charges stemming from those hours worked. The result is shown as below.

Create a stored procedure to include the companyname, last order date, ship address for company names the begin with an A Using NorthWind database in Microsoft SQL server

answer with proper explanation and step by step solution. Question write a PL/ SQL program to display the number of products whose price is 100 dh more or less than the price defined the for substitution variable use the define command to specify the price pass this value to the PL/SQL black using a substitution variable

create  a PL/SQL code to determine which employee works for which city and report their increase based on the city.  when employee is in city A ,salary lower then 10000, tey will get 10%more salary  in city b ,salary lower then 10000, they will get 15%more salary  all others  ,they will only get 5% more . how to do this ? display   salary , increased salary .salary in one year , first_name    last_name ,emp id and city  SELECT employee_id, salary, salary*12 , city From employees JOIN departments

Create a SQL query to display the combined customer name, employee id, delivery notes, coinordered and invoice number. In your query only display the results that have any invoice date from 18th May 2021. CUSTOMER EMPLOYEE_ID DESCRIPTION COIN INVOICE_NUM INVOICE_DATE Lucy, Williams emp103 Delivery to work address 1oz Gold Palaeontology 8116 18-MAY-21 Julien, Hendricks emp105 Double packaging requested 1oz Silver Kruger Rand 8117 19-MAY-21 Sam, Clark emp105 Double packaging requested 1oz Silver Kruger Rand 8118 19-MAY-21

7. List the shipping city and state for the order that had the longest shipping delay. SQL commands

Include both SQL commands and SQL results in your answers: KimTay Pet Supplies is running a promotion that is valid for up to 20 days after an order is placed. List the invoice number, customer ID, customer first and last names, and the promotion date for each invoice. The promotion date is 20 days after the invoice was placed. Write PL/SQL (or MySQL) procedures to accomplish the following task: The procedure accepts the ID of a customer stored in the input variable named I_CUST_ID and displays the name (first name concatenated with last name) and credit limit of for this customer.