Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use northwind database to answer these questions 7. Northwind has finally decided to give all employees an email address. The domain name will be northwind.com.
Use northwind database to answer these questions
7. Northwind has finally decided to give all employees an email address. The domain name will be northwind.com. Create a list of employee first and last names and email addresses in the format of first initial.Lastname@northwind.com. (Note the period between first initial and last name) Their ISP requires all email address to be submitted in lowercase. Sort by last name in ascending order. 8. List all customers who live in the following countries: France, Germany, USA or UK. Use the IN Keyword. Sort by Country. 9. List the largest 5 percent of freight charges along with the CustomerID. 10. The employee table Notes column contains a great deal of information concerning each employee including the languages they speak. Northwind needs someone who speaks German to represent the company at a meeting. List the LastName, HomePhone and Notes of any employee with German in the notes 11. List all orders with an order date in July 2014. Use the Between Keyword 12. List all orders with an order date in July 2014. DO NOT use the between KeywordStep 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