#### Doing Joins Inner Join SELECT Firstname, Lastname, title FROM employee INNER JOIN title ON title.titleid...

Transcribed Image Text:

#### Doing Joins Inner Join SELECT Firstname, Lastname, title FROM employee INNER JOIN title ON title.titleid employee.titleid; #### Doing Joins - Right Join SELECT Firstname, Lastname, title FROM employee RIGHT JOIN title ON title.titleid = employee.titleid; #### Doing Joins with WHERE and ORDER BY parts Select EmpID, Firstname, Lastname, Title FROM employee INNER JOIN title ON employee. TitleID WHERE Lastname = 'Smith' ORDER BY Firstname = title. TitleID This homework section is about writing SQL statements with Join clauses. The Join statement will allow connected tables to be put together in a row. You may need to use other sources when completing the exercise. This will help you build your critical thinking skills and problem-solving abilities. Create and run the described query and then copy/paste it into the appropriate text field. Make sure you upload screenshots of the results. 1. Create a query that shows all the users name and telephone numbers of each person. Make sure you sort everyone by first name and last name. Who if anyone does not have a telephone number.* 2. Show everyone with a their name, title, and salary. Sort the list by salary. 3. Show everyone's name in the database. Show the training that they took. If some one has not done training their name should still show up. 4. Create a query that shows all the user's first and last name and their cell number. If they don't have a cell number they should still show just their name. This one requires the ON part to match Empld = Peopleid and PhoneType = 'Cell' 5. Create a query that has the user's first and last name, Title, and Telephone numbers. You can put the Inner joins one right after another. You will need 3 tables (employee, title and phone). So do an inner join for title then do an inner join for phone. Order the list by Firstname, Lastname* 6. Show everyone and the courses that they have taken. You will have to connect up three tables using this. Order the list by Firstname, Lastname* student250 New employee Columns New EmplD Firstname Lastname Salary StartDate TitleID Indexes New PRIMARY empl_train Columns New EmpID id TrainID Indexes New phone title EmpID PRIMARY Columns New PeopleiD Phoneid PhoneNumber Phone Type Indexes New PRIMARY Columns New Title TitleID Indexes New training Columns New TrainID Training_Name Indexes New PRIMARY #### Doing Joins Inner Join SELECT Firstname, Lastname, title FROM employee INNER JOIN title ON title.titleid employee.titleid; #### Doing Joins - Right Join SELECT Firstname, Lastname, title FROM employee RIGHT JOIN title ON title.titleid = employee.titleid; #### Doing Joins with WHERE and ORDER BY parts Select EmpID, Firstname, Lastname, Title FROM employee INNER JOIN title ON employee. TitleID WHERE Lastname = 'Smith' ORDER BY Firstname = title. TitleID This homework section is about writing SQL statements with Join clauses. The Join statement will allow connected tables to be put together in a row. You may need to use other sources when completing the exercise. This will help you build your critical thinking skills and problem-solving abilities. Create and run the described query and then copy/paste it into the appropriate text field. Make sure you upload screenshots of the results. 1. Create a query that shows all the users name and telephone numbers of each person. Make sure you sort everyone by first name and last name. Who if anyone does not have a telephone number.* 2. Show everyone with a their name, title, and salary. Sort the list by salary. 3. Show everyone's name in the database. Show the training that they took. If some one has not done training their name should still show up. 4. Create a query that shows all the user's first and last name and their cell number. If they don't have a cell number they should still show just their name. This one requires the ON part to match Empld = Peopleid and PhoneType = 'Cell' 5. Create a query that has the user's first and last name, Title, and Telephone numbers. You can put the Inner joins one right after another. You will need 3 tables (employee, title and phone). So do an inner join for title then do an inner join for phone. Order the list by Firstname, Lastname* 6. Show everyone and the courses that they have taken. You will have to connect up three tables using this. Order the list by Firstname, Lastname* student250 New employee Columns New EmplD Firstname Lastname Salary StartDate TitleID Indexes New PRIMARY empl_train Columns New EmpID id TrainID Indexes New phone title EmpID PRIMARY Columns New PeopleiD Phoneid PhoneNumber Phone Type Indexes New PRIMARY Columns New Title TitleID Indexes New training Columns New TrainID Training_Name Indexes New PRIMARY

Answer rating: 100% (QA)

Query 1 To create a query that shows all the user names and telephone numbers of each person sorted by first name and last name and identify those who do not have a telephone number SELECT eFirstname ... View the full answer