Question: Could you please answer theses two questions in your own words and it doesn't need the use of Access, Excel, etc to show the work
Could you please answer theses two questions in your own words and it doesn't need the use of Access, Excel, etc to show the work
1) Using the following Cash table, show the show the output if the following SQL command is given :
Select Account#, Balance
From Cash
Where Balance < 50000;
Account # types Bank Balance
BA-6 Checking Boston5 253
BA-7 Checking Shawmut 48,000
BA-8 Draft Shawmut 75,000
BA-9 Checking Boston5 950
2) Using the following Cash table, show the show the output if the following SQL command is given :
SELECT Account#, Balance
FROMCash
WHERE Bank = "Boston5"
ORDER BY Amount DESC;
Account # types Bank Balance
BA-6 Checking Boston5 253
BA-7 Checking Shawmut 48,000
BA-8 Draft Shawmut 75,000
BA-9 Checking Boston5 950
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
