Suppose that you want to find all orders that are in shipped status and have the total amount greater than 1500, you can join the orderdetails table with the orders table using the inner join clause and apply a condition on status column and total aggregate as shown in the following query:
a) True
b) False