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.

ScholarMatic: Explanation & Answer

Your ready answer from a verified tutor is just a click away for as little as $14.99

---

  

Click Order Now to get 100% Original Answer Customized to your instructions!