SQL> select prod_name, cust_gender, day_name, sum(amount_sold) as totalsold

2 from sh.products, sh.customers, sh.times, sh.sales

3 where prod_name like ('Deluxe Mouse')

4 group by prod_name, cust_gender, day_name

5 having cust_gender='female' and (day_name='friday' or day_name='thursday');

For the query above suppose that Star transforms were applied to it.

Hand write or type the nested queries that Star transform will add to the query