Download Display the resortid, name of the resort ,booking count and the total ... book pdf free download link or read online here in PDF. Read online Display the resortid, name of the resort ,booking count and the total ... book pdf free download link book now. All books are in clear copy here, and all files are secure so don't worry about it. This site is like a library, you could find million book here by using search box in the header.
r.resortname, count(*) totalbooking , sum(b.totalcharge) as totalamount from resort r inner join booking b on b.resortid = r.resortid group by r.resortid, r.resortname order by r.resortid; Note that table aliases make the query easier to write and read. This gives you one row per resort, with the total number of bookings and the sum of totalcharge.
| Read : Display the resortid, name of the resort ,booking count and the total ... pdf book online Select one of servers for direct link: |
|---|