Hello , Excuse How I can Solved These Five Question ?

I will Use , Inner Join , Left Join , Right Join , Self Join , Full Join !

Open the AdventureWorks database and get a query window for that database. Make sure you are in the right database by looking at the text at the top of the query window. 1. Join (with inner join) together person, personphone, businessentity and phonenumber type in the persons schema. Return first name, middle name, last name, phone number and the name of the phone number type (home, office, etc.) Order by business entity id descending. 5. Join (Inner) productmodel, productmodelproductiondescriptioncult ure, productdescription and culture from the production schema. Return the productmodel name, culture name, and productdescription description ordered by the product model name. 3 Add a join to previous example to production.product and return the product name field in addition to other information. 4. Join product and productreview in the schema table. Include every record from product and any reviews they have. Return the product name, review rating and comments. Order by rating in ascending order. 5. Use a right join to combine workorder and product from production schema to bring back all products and any work orders they have. Include the product name and workorder orderqty and scrappedqty fields. Order by productid ascending. Open the AdventureWorks database and get a query window for that database. Make sure you are in the right database by looking at the text at the top of the query window. 1. Join (with inner join) together person, personphone, businessentity and phonenumber type in the persons schema. Return first name, middle name, last name, phone number and the name of the phone number type (home, office, etc.) Order by business entity id descending. 5. Join (Inner) productmodel, productmodelproductiondescriptioncult ure, productdescription and culture from the production schema. Return the productmodel name, culture name, and productdescription description ordered by the product model name. 3 Add a join to previous example to production.product and return the product name field in addition to other information. 4. Join product and productreview in the schema table. Include every record from product and any reviews they have. Return the product name, review rating and comments. Order by rating in ascending order. 5. Use a right join to combine workorder and product from production schema to bring back all products and any work orders they have. Include the product name and workorder orderqty and scrappedqty fields. Order by productid ascending