Write SQL code for the following questions:Add a new table called SALES_YourFirstName. Please note that “YourFirstName” is your first name. this table should have a minimum of 4 attributes, with at least one foreign key.Write the code to delete the above table from the database.Show the age of the oldest employee.For each employee show their full name, start date, and the name of the department that they work for.Add a new product to the Products table. The product quantity must be in the range of 1-100.Show the name and email address for Suppliers that have “@money” in their email address.For each product that has a quantity less than 50, show its name, quantity, department name, and supplier name.Show a list of products ordered by quantity, from smallest to largest. Include only the product name and the quantity in stock.Prompt the user to enter a date and show the full name and DOB of employees born on that date.For each supplier, show the number of products that are available for each.

As per company guidelines we are suppose to answer only 1 question. Kindly re-post other questions…

Answered: Write SQL code for the following…

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...

Related questions

Question

Write SQL code for the following questions:

Add a new table called SALES_YourFirstName. Please note that “YourFirstName” is your first name. this table should have a minimum of 4 attributes, with at least one foreign key.
Write the code to delete the above table from the database.
Show the age of the oldest employee.
For each employee show their full name, start date, and the name of the department that they work for.
Add a new product to the Products table. The product quantity must be in the range of 1-100.
Show the name and email address for Suppliers that have “@money” in their email address.
For each product that has a quantity less than 50, show its name, quantity, department name, and supplier name.
Show a list of products ordered by quantity, from smallest to largest. Include only the product name and the quantity in stock.
Prompt the user to enter a date and show the full name and DOB of employees born on that date.
For each supplier, show the number of products that are available for each.