Queries to get room and furniture details of IUB

furniture.sql

SELECT 
	ep.title AS Equipment_Type,
	e.title AS Equipment,
	e.picture
	
FROM 
equipments e
INNER JOIN equipements_type ep ON (( ep.id = e.type_id ))

GROUP BY
	ep.title

ORDER BY
	ep.title,
	e.title
ASC

LIMIT 5

iub_rooms.sql

SELECT
	c.title AS Campus,
	b.building_title AS Building,
	rt.room_type_title AS Room_Type,
	CONCAT(r.room_number, ' - ', r.room_name) AS Room
FROM
	buildings b
	INNER JOIN campus c ON (( c.id = b.campus_id ))
	INNER JOIN rooms r ON (( r.building_id ))
	INNER JOIN room_types rt ON (( rt.room_type_id = r.room_type_id ))
	
GROUP BY
	c.title,
	b.building_title
ORDER BY
	c.title,
	b.building_title
ASC