Suppose we want to find all orders that has shipped and has total sales greater than $1500, we can join the orderdetails table with the orders table by using the INNER JOIN clause, and apply condition on the status column and the total aggregate as the following query: