Q.6.3 Assume that all the statements from Q.6.2 have been executed on the database. Q.6.3.1 Write...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Q.6.3 Assume that all the statements from Q.6.2 have been executed on the database. Q.6.3.1 Write a SQL statement to get the list of all the team members in the database. Include only the name and email address of the team members. The Independent Institute of Education (Pty) Ltd 2022 21; 22; 23 Q.6.3.2 Write a SQL statement to get the list of all the tasks that started after 2022-05-10. Include all the columns from the task table. Q.6.3.3 Write a SQL statement that returns a list of the team members with all their tasks. Include the team member's name and the description of the task in the results. Q.6.3.4 Write a SQL statement to get a list of the tasks in the database, arranged by duration from largest to smallest. Include all the columns from the Task table. Q.6.3.5 Write a SQL statement to get the total duration of all the tasks that Pag Primary key: Team MemberID Team MemberID 1 2 3 Team MemberName Joe Bloggs Samantha Smith Pete Ngwenya Table: Task Primary key: TaskID Foreign key: Team MemberID TaskID 1 2 3 Description Build login screen Implement inventory management Add logo to splahs screen Duration StartDate 4 10 Team MemberEmail joe@theoffice.com sam@theoffice.com pete@theoffice.com 1 Team MemberID 2022-05-06 1 2022-05-15 1 2022-05-06 2 Q.6.3 Assume that all the statements from Q.6.2 have been executed on the database. Q.6.3.1 Write a SQL statement to get the list of all the team members in the database. Include only the name and email address of the team members. The Independent Institute of Education (Pty) Ltd 2022 21; 22; 23 Q.6.3.2 Write a SQL statement to get the list of all the tasks that started after 2022-05-10. Include all the columns from the task table. Q.6.3.3 Write a SQL statement that returns a list of the team members with all their tasks. Include the team member's name and the description of the task in the results. Q.6.3.4 Write a SQL statement to get a list of the tasks in the database, arranged by duration from largest to smallest. Include all the columns from the Task table. Q.6.3.5 Write a SQL statement to get the total duration of all the tasks that Pag Primary key: Team MemberID Team MemberID 1 2 3 Team MemberName Joe Bloggs Samantha Smith Pete Ngwenya Table: Task Primary key: TaskID Foreign key: Team MemberID TaskID 1 2 3 Description Build login screen Implement inventory management Add logo to splahs screen Duration StartDate 4 10 Team MemberEmail joe@theoffice.com sam@theoffice.com pete@theoffice.com 1 Team MemberID 2022-05-06 1 2022-05-15 1 2022-05-06 2
Expert Answer:
Related Book For
Understanding Business Ethics
ISBN: 9781506303239
3rd Edition
Authors: Peter A. Stanwick, Sarah D. Stanwick
Posted Date:
Students also viewed these computer network questions
-
References: Health Information Management Case Studies Second Edition AHIMA by Dianna M. Foley Health Information Management Technology an Applied Approah Sixth Edition AHIMA by Nanette Sayles and...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
Find a minimum spanning tree for the following graph using all 3 algorithms 13 17 22- 20 15, a. Adding the shortest edge first b. Deleting the longest edge first c. Growing a tree from the node D
-
In 1982, the ITC instituted an investigation to determine if motorcycles having engines with displacement more than 700 cubic centimeters were being imported into the United States in such increased...
-
The Art Appreciation Society operates a museum for the benefit and enjoyment of the community. When the museum is open to the public two clerks who are positioned at the entrance collect a $5.00...
-
Do you think Roe v. Wade is an example of legislating morality? Why or why not?
-
Use the Rolling Hills, Inc. data from Problem P14-34A. Requirements 1. Prepare the 2018 statement of cash flows by the direct method. 2. How will what you learned in this problem help you evaluate an...
-
3. Prepare an unadjusted trial balance as of October 31, 2016. How does grading work? Affordable Realty UNADJUSTED TRIAL BALANCE October 31, 20Y6 ACCOUNT TITLE Score: 40/47 DEBIT CREDIT 1 Cash 2...
-
A man from Vietnam is in your office because his 11-year-old daughter has been having trouble in school. The school suggested the daughter be tested by your agency. You are doing the intake, but only...
-
Hayes & Grant Wholesale received an invoice dated March 30, 2018, from a manufacturer that sells electronic components. The list price was $18,427. This manufacturer offers its customers a trade...
-
what ways do modern businesses leverage advanced methodologies, such as predictive analytics and sentiment analysis, to gauge and enhance employee engagement on a continuous basis?
-
A firm is considering two projects, A and B. Each project will last for 4 years. The projected cash flows for each project are shown below: Year 0 1 2 3 4 Project A -20 7 6 6 5 Project B -25 11 5 7 4...
-
With interest rates near an all-time low, a family decides to purchase their dream home. The house will cost $300,000. The family will pay 15% as a down payment, and finance the remaining balance...
-
What role does advanced talent development and career progression frameworks play in sustaining high levels of employee engagement, particularly amidst rapid technological advancements and evolving...
-
7. A sport utility vehicle (SUV) sells for $34,200 and leases for $348 plus tax per month for a lease term of 24 months. A down payment of $3500 is required. The guaranteed residual value of the...
-
Figure 1 shows a type of filter implemented into a signal processing system with its related components values. (Rajah I memanjukkan jenis penapis yang dilaksonakan ke dalam sistem pemprasesan...
-
Suppose the S&P 500 futures price is 1000, = 30%, r = 5%, = 5%, T = 1, and n = 3. a. What are the prices of European calls and puts for K = $1000? Why do you find the prices to be equal? b. What...
-
Which of the teleological frameworks most closely match your ethical beliefs? Under what circumstances would you shift toward another of the frameworks? For example, if you were trapped in downtown...
-
Wal-Mart began as a simple dream by its founder, Sam Walton, to provide low prices for customers every day. That philosophy has taken Wal-Mart from one pre-Wal-Mart 5-and-10-cent store in...
-
On October 29, 2003, Richard Scrushy, the former CEO of HealthSouth, was indicted by the federal government on 85 counts of fraud. He was released on a $10 million bond and a proposed trial date was...
-
The Jenkins supermarket manager claims that the scanning errors on purchased items are random, and about half of the errors are in favor of the supermarket. Decide whether the statement makes sense...
-
At a particular moment, the U.S. Census Bureau population clock shows that the global population is 7,118,233,027 people. Describe the accuracy and precision of that population number. Data From...
-
When recording the weight of a watermelon, a supermarket clerk writes the wrong number. Is this type of error a random error or a systematic error? Explain.
Study smarter with the SolutionInn App