Question

This command was used to create a table: create table vehicletype (carid integer primary key, typeofvehicle text, manufacturer text,year integer); at least 25 rows have been inserted with different types of vehicles (truck, sedan, suv, sport) and manufacturer (chevrolet, ford, toyota, etc.), and year the vehicle was manufactured. what would be the result of this command: select * from vehicletype where typeofvehicle

Answer 1

Here is the full question:

CREATE TABLE vehicletype (carid INTEGER PRIMARY KEY, typeofvehicle TEXT, manufacturer TEXT,year INTEGER);

At least 25 rows have been inserted with different types of vehicles (truck, sedan, SUV, sport, etc.) and manufacturer (Chevrolet, Ford, Toyota, etc.), and year the vehicle was manufactured. What would be the result of this command:

Select * FROM vehicletype WHERE manufacturer=”Ford” ORDER BY year;

Answer:

This is an example of SQL- standard query language. SQL is used to query and update relational databases.

Within the query 'Select * FROM vehicletype WHERE manufacturer=”Ford” ORDER BY year;'

'Select *' means select all fields

'from vehicletype' means from the table vehicletype

'Where' precedes the conditions for the selection: which rows are to be selected

'manufacturer=”Ford"'' select the rows where the manufacturer has been set to 'Ford'

'ORDER BY year' means order the selected rows by year from earliest to latest.