Sql Server Northwind Database Exercises
Select the names of employees who are strictly older than: (a) an employee who lives in London. (b) any employee who lives in London. Select the name of employees who work longer than any employee of London. Select the name of employees and the city where they live for employees who have sold to customers in the same city. Select the name of customers who have not purchased any product. Select the name of customers who bought all products with price less than 5. Select the name of the products sold by all employees. Select the name of customers who bought all products purchased by the customer whose identifier is 'LAZYK' Select the name of customers who bought exactly the same products as the customer whose identifier is 'LAZYK' Select the average price of products by category. Given the name of the categories and the average price of products in each category. Select the identifier and the name of the companies that provide more than 3 products. Select the identifier, name, and number of orders of employees, ordered by the employee identifier.
Sql Server Northwind Database Exercises
Also check out this link answered Jul 1 '09 at 4:23 Prashanth Prashanth 2, 206 1 gold badge 16 silver badges 19 bronze badges If you have Reporting Services handy, or even Visual Studio, creating a few reports with aggregates, sums, counts etc will give you a little insight to how data can be used as information and really boost your SQL skills. I work in a telephony company where this goes on all the time. I have this book sitting on my desk which I have found really handy. Good luck! :) answered Jul 1 '09 at 14:16 Not the answer you're looking for? Browse other questions tagged sql sql-server sql-server-2005 tsql or ask your own question.
Only show records for products for which the quantity ordered is fewer than 200 ( Create a report that shows the total number of orders by Customer since December 31, 1996.
Select a list of customer names who have no orders in the Orders table. Add a shipper named 'Amazon' to the Shippers table using SQL. Change the company name from 'Amazon' to 'Amazon Prime Shipping' in the Shippers table using SQL. Select a complete list of company names from the Shippers table. Include freight totals rounded to the nearest whole number for each shipper from the Orders table for those shippers with orders. Select all employee first and last names from the Employees table by combining the 2 columns aliased as 'DisplayName'. The combined format should be 'LastName, FirstName'. Add yourself to the Customers table with an order for 'Grandma's Boysenberry Spread'. Remove yourself and your order from the database. Select a list of products from the Products table along with the total units in stock for each product. Give the computed column a name using the alias, 'TotalUnits'. Include only products with TotalUnits greater than 100. Select the name, address, city, and region of employees.
Sql server northwind database exercises answer
- Sql server northwind database exercices interactifs
- Principios de bioquimica lehninger 5 edicion pdf español
- SQL Exercises for PUBS and Northwind SQL Sevrer database
- La psicología medica en la medicina - Monografias.com
- Sql server northwind database exercices.free
- Exercises on Northwind Database | Databases | Information Technology Management
- Sql server northwind database exercises practice
- Sql server northwind database exercises solutions
- Devoile moi ebook pdf telecharger
- Sql server northwind database exercises worksheet
- Sql server northwind database exercises list
Welcome to the Forums. You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact March 20th, 2009, 05:46 AM Registered User Join Date: Mar 2009 Posts: 2 Thanks: 0 Thanked 0 Times in 0 Posts SQL Exercises for PUBS and Northwind SQL Sevrer database Hi, I am new to SQL Server and have recently bought SQL Server 2000 programming by Rob Viera. But I want to polish my SQL Query and Procedure writing skills. So can anybody point me to SQL Exercises targetting Pubs and Northwind database or any other database? Thanks in advance, Jai. March 21st, 2009, 04:41 AM SQL Exercises March 23rd, 2009, 07:13 AM Hi MSI, Your reply links were very helpful.
The PHP Certificate documents your knowledge of PHP and MySQL. The XML Certificate documents your knowledge of XML, XML DOM and XSLT. The Bootstrap Certificate documents your knowledge of the Bootstrap framework.