Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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.

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.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter10: Data Analysis With Power Tools And Creating Macros
Section: Chapter Questions
Problem 9AYK
See similar textbooks
icon
Related questions
Question

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.

Table: Team Member Primary key: Team MemberID Team MemberID 1 2 3 Table: Task Primary key: TaskID Foreign key: Team MemberlD TaskID 1 2 3 Team MemberName Joe Bloggs Samantha Smith Pete Ngwenya Description Build login screen 4 Implement inventory 10 management Add logo to splahs 1 screen Duration TaskID 4 Description Implement email Team MemberEmail joe@theoffice.com sam@theoffice.com pete@theoffice.com Q.6.2.1 Write a SQL statement to create the table Task. StartDate 2022-05-06 1 2022-05-15 1 2 TeamMemberID Hint: The sample data should give you an indication of the data types you should use. Q.6.2.2 Write a SQL statement that will add the below row to the Task table. Duration StartDate Team MemberID 2022-05-07 3 2022-05-06 2 notifications Q.6.2.3 Write a SQL statement that will change the value of the Task description with ID 3 to "Add logo to splash screen".
Transcribed Image Text:Table: Team Member Primary key: Team MemberID Team MemberID 1 2 3 Table: Task Primary key: TaskID Foreign key: Team MemberlD TaskID 1 2 3 Team MemberName Joe Bloggs Samantha Smith Pete Ngwenya Description Build login screen 4 Implement inventory 10 management Add logo to splahs 1 screen Duration TaskID 4 Description Implement email Team MemberEmail joe@theoffice.com sam@theoffice.com pete@theoffice.com Q.6.2.1 Write a SQL statement to create the table Task. StartDate 2022-05-06 1 2022-05-15 1 2 TeamMemberID Hint: The sample data should give you an indication of the data types you should use. Q.6.2.2 Write a SQL statement that will add the below row to the Task table. Duration StartDate Team MemberID 2022-05-07 3 2022-05-06 2 notifications Q.6.2.3 Write a SQL statement that will change the value of the Task description with ID 3 to "Add logo to splash screen".
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Single Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
SEE MORE TEXTBOOKS