Givethename,address,city,om E in Employeesselect new 22. To select columns from multiple tables with joins. Give the customer name and the product name such that the quantity of this productbought by the customer in a single order is more than 5 times the average quantityofthisproductboughtinasingleorderamongallclients.1NorthwindDatabaseQueryingwithLinqAnswers1. In this lesson of the NorthWind SQL tutorial, you will learn. Givethenamesofemployeeswhoselltheproductsofmorethan7suppliers.26. Givetheidentier, name, andtotal salesof employees, orderedbytheemployeeidentierforemployeeswhohavesoldmorethan70dierentproducts.25. Givetheidentier, name, andtotal salesof employees, orderedbytheemployeeidentier.24. and copy its contents in MySql Workbench Query window and click Execute. Foreachemployeegivetheidentier, name, andthenumberof distinctproductssold,orderedbytheemployeeidentier.23. Microsofts Northwind database is available for SQL Server and MS Access but it. Givetheidentier, name, andnumberofordersofemployees, orderedbytheem-ployeeidentier.22. I want ,which product was sold maximumly according to sales turnover. I want max sales of employees according to product. Give the identier and the name of the companies that provide more than 3 products.21. I make effort to get a query from from northwind database sample. Given the name of the categories and the average price of products in each category.20. Givetheaveragepriceofproductsbycategory.19. Give the name of customers who bought exactly the same products as the customerwhoseidentierisLAZYK18. Givethenameof customerswhoboughtall productspurchasedbythecustomerwhoseidentierisLAZYK17. Givethenameoftheproductssoldbyallemployees.16. Givethenameofcustomerswhoboughtallproductswithpricelessthan5.15. Givethenameofcustomerswhohavenotpurchasedanyproduct.14. Givethenameof employeesandthecitywheretheyliveforemployeeswhohavesoldtocustomersinthesamecity.13. GivethenameofemployeeswhoworklongerthananyemployeeofLondon.12. Givethenamesofemployeeswhoarestrictlyolderthan:(a) anemployeewholivesinLondon.(b) anyemployeewholivesinLondon.11. GivethenameofproductsthatwereboughtorsoldbypeoplewholiveinLondon.Writetwoversionsofthequery,withandwithoutunion.10. Givethecustomername, theproductnameandthesuppliernameforcustomerswholiveinLondonandsupplierswhosenameisPavlova,Ltd. Give the name and title of employees and the name and title of the person to whichtheyrefer(ornullforthelattervaluesiftheydontrefertoanotheremployee).8. Givethetitleandnameof employeeswhohavesoldatleastoneof theproductsGravadLaxorMishiKobeNiku.7. GivetheemployeenameandthecustomernameforordersthataresentbythecompanySpeedyExpresstocustomerswholiveinBrussels.6. Writetwoversionsofthequery,withandwithoutjoin.5. List each name only once and list the names in.
Give the name, address, city, and region of employees that have placed orders to bedeliveredinBelgium. contain the company names of all customers who have placed an order.
Givethename,address,city,andregionofemployeesolderthan50yearsold4. Givethename,address,city,andregionofemployees.2.
0 kommentar(er)
