Show the SQL query. b) Run the query in MySQL. How many rows are returned? c) List
Question:
Show the SQL query.
b) Run the query in MySQL. How many rows are returned?
c) List just the first two rows from the results of the query. (You can "cut and paste" the query results; Otherwise, you can also type them, referring to the results of the query)
This query refers to the stocksdb. (In MySQL, make sure you run the command - USE stocksdb;) (Multi-Table Query)
Display the customer name, stock symbol, company name, and quantity owned for customers who own stocks with Beta in the range of 0.2 to 0.7 and when the quantity owned exceeds 325. Sort the results by customer name and stock symbol. (Hint: Recall that ownership of stocks is reflected in the Portfolio table)
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last