Answered You can hire a professional tutor to get the answer.

QUESTION

Hi I need help with these sql questions equation ?

Hi I need help with these sql questions equation ? Need sql input (Select,From,Where,Group by,Orderby) Data is not needed just need to get idea what to put for sql equation.

example

(BilledAmt) , VetId Visit

(VisitDate)

Vetid

(BilledAmt)

List details for the appointments where the billed amount is greater than the specialty rate for that attending vet.

List for each owner the total amount they have been billed for all their appointments in 2014 combined. However only show the results if the total exceeds $2000.

List the owner details for patients who are a "Cat" type of either the "Persian" or "Siamese" breed. Show each owner only once.

List the id, name and specialty for every Vet that has attended appointments in June 2014. Show each Vet only once. Sequence by name within specialty.

List the details for the owners that have had appointments in 2013. Only show each owner once and sequence by owner email.

List the details for all appointments scheduled for March 2015. Sequence the appointments by earliest date first sequence.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question