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
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