Question: Software Requirement: Microsoft SQL Server Management Studio 18.0 or higher Microsoft SQL Server Express 2017 Instructions Create queries for the following items. 1. The company

Software Requirement: Microsoft SQL Server Management Studio 18.0 or higher Microsoft SQL Server Express 2017 Instructions Create queries for the following items. 1. The company manager requested to view the list of employees on the system, including employee ID and status. To comply with the request, create a query that shows the Employeeld, FirstName, LastName, and Status in the Employee table on the database. 2. Company XYZ manually viewed all the products and purchased items in their list. They have an existing system, but it does not have the function to view the products and purchased items. They requested to add a function to the developer. To comply with the request, create a query that displays the columns of the Product table and the Purchase table. 3. Company ABC requested to remove the existing database and create a new database for the new system. To comply with the request, write a query that creates a new database named dbo.Products and removes the database named dbo.Items
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
