Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Help please or email me wowser100 gmail Write a query to list the following columns from the Employees table. The Date of Hire is given
Help please or email me wowser100 gmail
Write a query to list the following columns from the Employees table. The Date of Hire is given in the table; you are required to calculate the duration of employee service in years. You will use the DateDiff function and find the difference in years when the employee was hired compared to today's date. Once you have calculated the YearsofService, limit your output to Female employees only and years of service between 31 and 35 . Your output will match the given output if the query is written as asked. Table: Employees Write a query using the Sales and Salesltems tables (both are related and already joined). InvoiceID and OrderDate are picked from the Sales table, and Quantity and UnitPrice are from the SalesItems table. You are required to calculate the ExtendedPrice and 10\% Discount for the ExtendedPrice. If you look at the output carefully, The InvoiceID repeats itself, indicating several line items for each Invoice. Tables: Sales and SalesItems (Total rows 2192) Before writing this query, please watch the training video (Part 4); follow the training video and limit the results to the Year 2014. Tables: Sales and Salesitems (Total rows 2192) Write a query to retrieve EmployeeID and concatenate first and last names to make the full name. your filter condition will identify only 'Sales trainee.' Your query output will match the given output. Table: Employees write a query to retrieve InventoryID, name, and OnHand quantity. Apply a filter to identify only product names having 'Raspberry' in them. Your output will match the given output if the query is written as asked. Table: Inventory Write a query to retrieve InventoryID, Name, ONHand, and Price. You are required to calculate the ExtendedPrice (OnHand x Price). Your output will only include products having 'Chocolate' in their name, and the ExtendedPrice is between 15000 and 20000 . Your output will match the given output if the query is written as asked. Table: Inventory Write a query to retrieve CustomerID, CompanyName, State, and CreditLimit. I am only interested in listing two states, WV and RI. You noticed that there are CreditLimit for a few Customers. Please list customers with Credit Limit only (Remove the rows with no credit limit). For the remaining three queries, you will need to create a query that will be used as a source query combined with other tables. The query specs are here: The sales Table and Salesltems table will be combined together, and your query will include the following fields. If you need help, let me know. Field InvoicelD Invoiceoste CustomeriD Employecid \begin{tabular}{l} Inventond \\ Salesitems \\ \hline \end{tabular} Cuantity Salesiltems UnitPrice ExtendedPrice: IQusn Save the query as Sales_SalesItems_CombinedStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started