Write a SQL statement Oracle 12g Chapter 9 Produce a list of

Write a SQL statement, Oracle 12g Chapter 9- Produce a list of all customers who live in the state of Florida and have ordered books about computers.

Solution

select cust_name from Customers where state=\'Florida\' AND cust_id in(select cust_id from Orders where count(cust_id)>=1 AND book_id in(select book_id from Books where category=\'Computers\') group by cust_id)