Matching multiple information and bring the result

[Ibrarbutt]

Table 1

Booked By	Hotel Name	Room Type	No of Room	Amount<strike></strike>
ABC	Royal Hotel	Single Room	3	1400
ABC	Royal Hotel	Twin Room	2	1600
ABC	Mid Night Hotel	Single Room	4	1200
XYZ	Royal Hotl	Single Room<strike></strike>	4	100
ZYX	3 star Hotel	Twin Room	1	120
below 1000 records

<tbody>
</tbody>

Result (1) Required
Table 2

Hotel Name	Single Room	Twin Room	Amounts
Royal Hotel	Total of above	Total of above
Mid night Hotel
3 Star Hotel
may be 10 type of hotel

<tbody>
</tbody>

Result (2) Required

i have table with the list of booked by, i need to match with above table and bring below result.
Table 3

Booked By	Single Room	Twin Room	Amounts
ABC	Match with booking with table 1 and bring results as total	Total of above
XYZ
ZYX

<tbody>
</tbody>