#### Doing Joins Inner Join SELECT Firstname, Lastname, title FROM employee INNER JOIN title ON title.titleid...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
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
Related Book For
Concepts Of Database Management
ISBN: 9780357422083
10th Edition
Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt
Posted Date:
Students also viewed these programming questions
-
Question 7 Find 2 0 S S 0 3 (2x+5y) dxdy < >
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
identify where you are getting stuck and make it easier to find a solution. through complex problems and exploring different strategies for solving them. Simplify the problem: If the problem seems...
-
What minimum force f , applied horizontally to the wheel axis, is needed to bring the wheel up to the height step h ? Tomer as the wheel radius and w as its weight. Tip: apply the equilibrium...
-
When ethene is mixed with hydrogen in the presence of a platinum catalyst, hydrogen adds across the double bond to form ethane. At room temperature, the reaction goes to completion. Predict the signs...
-
Locate the court case Ellis v. Jarvis et al., 117 AFTR 2d 2016-1932. Using only the head notes, answer the following questions: a. What issue(s) did the court address? b. What was the ruling of the...
-
Comprehensive Problem: Reviewing the Accounting Cycle} Fodor Freight Service provides delivery of merchandise to retail grocery stores in northern Manitoba. At the beginning of 2018 , the following...
-
The following schedule indicates selected accounts from a citys preclosing 2015 and postclosing 2014 general fund trial balances: .:. All of the amounts shown relate only to supplies. All purchases...
-
answer asap with explanation 6. Determine the incorrect vector property. a) wxu =-uxw b) - v . u = -|v . u c)u-w=-wtu Hiptil gniwollol sits to splay siff spirmetal 7. Vector w represents the wind...
-
Several years after reengineering its production process, Dettling Corporation hired a new controller, Alana Metzgar. She developed an ABC system very similar to the one used by Dettling's chief...
-
Please don't plagiarize. Today's fast-paced, high-change project environments, coupled with organizations where formal project management may not be its strong suit, are often short on the necessary...
-
Consider the authors classification of technology into the basic characteristics of data storage, transmission, and processing capacity, and properties of communication and decision aiding. Would you...
-
The author states that successful SISP seems to require users and line managers working in partnership with the IS function. Who should be involved in SISP and how should those involved be determined?
-
What is the IT productivity paradox? Does it exist in your view, and if so, to what extent is it sectorally based? Do you believe it will remain a problem in, say, 5 years?
-
This chapter raises the important issue of improving customer support. What lessons do you take from this when considering information systems strategy and planning?
-
What role does financial accounting play in the allocation of society's financial resources?
-
Is the rationale for why plant assets are not reported at liquidation value. (Do not use the historical cost principle.) Indicates that personal and business recordkeeping should be separately...
-
Match the following. Answers may be used more than once: Measurement Method A. Amortized cost B. Equity method C. Acquisition method and consolidation D. Fair value method Reporting Method 1. Less...
-
Who is the oldest customer? a. Glenn Spencer b. Jess Hill c. Gene Shaffer d. Nour Aboud Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity...
-
Write the SQL code for the following: List the full name of the therapist scheduled to work on 10/16/2021. a. SELECT Therapist.FirstName, Therapist.LastName FROM Therapist WHERE Therapist.TherapistID...
-
The Sports Physical Therapy clinic uses supplies when conducting therapies on patients. The database administrator is creating a table that lists all the possible supplies that the clinic orders. The...
-
Compute direct materials efficiency variances (Learning Objective 4) Refer to the McDonalds Data Set on page 643. 1. Compute the direct materials efficiency variance for buns, hamburger patties, and...
-
Compute standard cost of direct labor (Learning Objective 3) Refer to the McDonalds Data Set on page 643. Compute the standard direct labor cost per hamburger. (Hint: Find the quantity and price...
-
Compute standard cost of direct materials (Learning Objective 3) Refer to the McDonalds Data Set on page 643. Compute the standard direct mate rials cost per hamburger.
Study smarter with the SolutionInn App