Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer this query based on these tables. Construct an SQL statement from oracle to answer this question. 1. How much did Kenya West received for
Answer this query based on these tables. Construct an SQL statement from oracle to answer this question.
1. How much did Kenya West received for the hours he worked?
Volunteer
Schedule
Invoice
VOLUNTEERID NAME ADDRESS CITY STATE POSTCODE PHONENO BIRTHDATE SEX A005 Ahmad Rahman 22 Deer Rd Klang Selangor 41050 0122810013 06/23/1996 M A007 Firdaus Ali 16 Argyll St Putrajaya Selangor 62000 0143655675 11/12/1989 M A003 Jacob Hamilton 163 Main St Klang Selangor 41050 0104652989 03/18/1994 M A004 Sara Johnson 32 Manse Rd Shah Alam Selangor 40450 0111210014 06/25/1998 F A002 Kenya West 56 Clover Dr Miri Sarawak 98200 0136560064 12/31/1992 M SCHEDULEID SCHEDULEDATE RATEPERHOUR HOURSWORKED VOLUNTEERID S002 12/02/2020 1 2 A007 s001 12/01/2020 2 3 A005 S003 12/03/2020 3 4. A004 S004 12/04/2020 6 12 A003 S005 12/05/2020 5 10 A002 INVOICEID RATEPERHOUR HOURSWORKED INVOICEDATE ALLOWANCE VOLUNTEERID SCHEDULEID C001 1 2 12/01/2020 2. A002 S001 C002 3 4 12/02/2020 12 A005 S002 C003 2 3 12/03/2020 6 A007 S003 C004 4 5 12/04/2020 20 A003 S004 C005 6 7 12/05/2020 42 A004 S005Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started