The Lucky Dog Grooming Parlor maintains data about each of its clients in a table named tblClients. Attributes include each dog’s name, breed, and owner’s name, all of which are text attributes. The only numeric attributes are an ID number assigned to each dog and the balance due on services. The table structure is tblClients(dogId, name, breed, owner, balanceDue). Write the SQL statement that would select each of the following:
a. Names and owners of all Great Danes
b. Owners of all dogs with balances due of more than $100
c. All attributes of dogs named Fluffy
d. All attributes of poodles whose balance is no greater than $50