How do we add questions on sam Blockly?
1 answer:
You might be interested in
Answer:
SELECT college, city_state, accre_agency, distance LIMIT 10
Explanation:
Given
Table name: College
See attachment for table
Required
Retrieve top 10 college, state, agency and school distance from the table
To retrieve from a table, we make use of the SELECT query
The select statement is then followed by the columns to be selected (separated by comma (,))
So, we have:
SELECT college, city_state, accre_agency, distance
From the question, we are to select only first 10 records.
This is achieved using the LIMIT clause
i.e. LIMIT 10 for first 10
So, the complete query is:
SELECT college, city_state, accre_agency, distance LIMIT 10
