SQL Queries, programming homework help

The following assignment is based on the database environment created in the Week Four Individual Assignment. Design and develop the below queries using professional principles and standards:

A set of SQL Statements that returns all rows and all data for each table in your database. Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause. Two SQL Statements that join two or more tables in one query.

Look for primary and foreign keys to help you determine join points. Use the JOIN clause as a part of your queries. Submit an .sql file with the scripts needed to create the required queries and submit the file using the Assignment Files tab. this is due on the 18th, it needs to be done in oracle but i do not have the knowledge in oracle to properly complete it. i am using this website: infinitiofaugusta.com , just the new inventory.

2016
2015
2014
2017
year
crossover
SUV
coupe
style
sedan
qx70
qx80
970
450
qx60
qx50
960
model
40k
price
50k
80k
60K
70k