CREATE DATABASE IF NOT EXISTS test3;



CREATE TABLE IF NOT EXISTS cars
(
carIdKey INT NOT NULL AUTO_INCREMENT,
ownerName VARCHAR(50) NOT NULL,
carMake VARCHAR(50) NOT NULL,
carModel VARCHAR(50) NOT NULL,
carYear DECIMAL (4, 0),
carColor VARCHAR(50) NOT NULL,
PRIMARY KEY (carIdKey)
);



INSERT INTO <database_name_here>.`cars` (
`carIdKey` ,
`ownerName` ,
`carMake` ,
`carModel` ,
`carColor`,
`carYear`
)
VALUES (
NULL , 
'Jeannie', 
'Toyota', 
'Solara', 
'2007', 
'Absolute Red'
);



INSERT INTO <database_name_here>.`cars` (
`carIdKey` ,
`ownerName` ,
`carMake` ,
`carModel` ,
`carColor`,
`carYear`
)
VALUES (
NULL , 
'Bill', 
'Chevrolet', 
'Corvette',
'1966', 
'Burnt Orange'
);



INSERT INTO <database_name_here>.`cars` (
`carIdKey` ,
`ownerName` ,
`carMake` ,
`carModel` ,
`carColor`,
`carYear`
)
VALUES (
NULL , 
'Ken', 
'Jaguar', 
'XKE',
'1966', 
'Pearl Essence Green'
);



SELECT * from cars ORDER BY ownerName ASC;