Please write queries based on the following requirements usi

Please write queries based on the following requirements using Premier Database..

List the state from which female members have placed more than 20 transactions. Show those state abbreviate and number of transactions. Rank your results from the highest to the lowest on total number of transactions.

database: https://onedrive.live.com/redir?resid=A1E5259BDD065B48!4478&authkey=!AH3fj0xU0Jv_Jyc&ithint=file%2caccdb

Writing SQL query as I don\'t have MS Access db,
select tr.Location, trd.Quantity from TRANSACTIONS tr, TRANSACTION_DETAILS trd, MEMBERS m where m.Gender=\'F\' and m.MemberID=tr.MEMBERID and tr.TransactionID=trd.TransactionID and trd.Quantity>20 ORDER BY trd.Quantity DESC

Please write queries based on the following requirements using Premier Database.. List the state from which female members have placed more than 20 transactions

Please write queries based on the following requirements usi

Solution

Get Help Now

Submit a Take Down Notice