How would I use a single SELECT query to display the total count of

sales, and the lowest, average, and highest sale price in SQL?? I have a SALES table and a VEHICLE table, but don’t know how to JOIN. I’ve tried the following, but receive error message:
SQL> SELECT COUNT (*) AS “COUNT OF SALES”, 2 AVG (WHOLESALE_COST) AS “AVERAGE SALES”, 3 MIN (WHOLESALE_COST) AS “LOWEST SALES”, 4 MAX (WHOLESALE_COST) AS “HIGHEST SALES” 5 FROM SALES s INNER JOIN VEHICLES v ON S.VIN = v.vin;