Question

I'm stuck to answer these questions. Can anyone help me to answer these questions? Thanks

Write Select statements to organize data from different tables.

• Select all clients who have had an assist; include client name, assist date and type.
• List all assists including the name of the Specialist.
• List client names having tasks needing follow up.
• List all clients having an assist in 2003; include client name and specialist name in the result.
• List all clients having an open assist; include client name, assist date and type, and specialist name in the result.

Sample Data

Clients
First	Last	Message Phone	Home Phone	Street*	City*	State*	Zip*
Terry	Bradshaw	3603333333	3603333333	303 4th	Olympia	WA	98501
Sam	Jones	3605545555		1525 Pacific	Olympia	WA	98501
Ginger	Baker	3608787878	3608787877
Sarah	Hughes	3604443333		8702 54th	Lacey	WA
Lovey	Howell	3607777777	3607777755	4226 X St.	Tumwater	WA	98501

*residence address

Specialists
First	Last	Title
BB	King	Specialist II
Ann	Wilson	Specialist I

Assists
Client	Open	Close	Specialist	Type	Referral	Ref. Phone	Confidential
3	10/2/04	12/12/04	1	Counseling	Dr. Jones		Yes
3	10/5/04	10/5/04	1	Referral	Dr. Barnes		No
4	11/21/04	1/6/05	1	Forms assistance
4	11/10/04	12/7/04	1	Counseling
3	12/1/04	12/1/04	2	Referral
3	12/18/04		2	Dr. Eligibility
4	12/8/04	1/10/05	2	Forms Assistance	Dr. Jason	3605555555
3	12/15/04	12/18/04	2	Counseling
1	12/12/04		1	Referral	DSHS		No
1	12/29/04	1/29/05	1	Advocacy
2	12/27/04	1/15/05	1	Dr. Eligibility

Tasks
Assist	Date	Followup	Activity	Status
2	10/05/04		Phone call	Complete
3	12/15/04		Phone call	Complete
4	12/1/04	Yes	Phone call
6	12/1/04		Letter	Complete
6	12/6/04		Phone call	Complete
7	1/5/05	Yes	Letter
10	1/4/05	Yes	Letter

Answer 1

If you have any doubts,please give me comment...

-- 1

SELECT CONCAT(First,',', Last) AS ClientName, A.Open AS AssistDate, Type

FROM Client C, Assists A

WHERE C.ClientID = A.ClientID;

-- 2

SELECT A.*, CONCAT(First,',', Last) AS SpecialistName

FROM Assist A, Specialists S

WHERE A.SpecialistID = S.SpecialistID;

-- 3

SELECT CONCAT(First,',', Last) AS ClientName

FROM Assist A, Client C, Tasks T

WHERE A.ClientID = C.ClientID AND A.AssistID = T.AssistID AND Followup = 'Yes';

-- 4

SELECT CONCAT(C.First,',', C.Last) AS ClientName, CONCAT(S.First,',', S.Last) AS SpecialistName

FROM Clients C, Assists A, Specialists S

WHERE C.ClientID = A.ClientID AND A.SpecilistID = S.SpecialistID AND YEAR(A.Open) = 2003;

-- 5

SELECT CONCAT(C.First,',', C.Last) AS ClientName, A.Open AS AssistDate, A.Type AS Type, CONCAT(S.First,',', S.Last) AS SpecialistName

FROM Clients C, Assists A, Specialists S

WHERE C.ClientID = A.ClientID AND A.SpecilistID = S.SpecialistID AND A.Close IS NULL;