SQL-Functions – SQL-Basics 3

In SQL-Basics

we learned the standard SQL statements to create a table, insert data into it, retrieving data from tables and altering data. Now we want to do even

Devon is a data driven man and to evaluate our mission, he likes to know from us:

• • how many missions we finished
  • the total cost of all missions
  • the mission with the lowest cost
  • the mission with the highest cost
  • the average mission cost
  • the five most expensive missions

SELECT COUNT(*) FROM missions;

SELECT SUM(total_cost) FROM missions;
SELECT MIN(total_cost) FROM missions;
SELECT MAX(total_cost) FROM missions;
SELECT AVG(total_cost) FROM missions;
SELECT * FROM missions ORDER BY total_cost DESC LIMIT 5;