# <center><i class="fa fa-edit"></i> SQL and Dashboard </center>
###### tags: `Internship`
:::info
**Goal:**
- [x] Build a Dashboard with SQL features following Notion Guide

**Resources:**
[Dashboard access mongoDB from NTUST](https://hackmd.io/@eric248550/BkZpSMjc9)
[2021 物聯網平台實習 (ET2702301)](https://hackmd.io/1vqhIDkqQKqF907HpneANw?view)
[Management Portal](https://portal-mp-ensaas.education.wise-paas.com/console)
[Dashboard Home](https://dashboard-ruiguang-ews.education.wise-paas.com/?orgId=1)
[在Dashboard完成視覺化的設置](https://hackmd.io/@RenJhang/HJ_ruIxVF)
[Notion](https://dawn-manatee-65a.notion.site/Dashboard-Page-aab2a4b9458443e3acf111baefefc7d1)
:::


SELECT office_name From office;

SELECT floor_name FROM floor, office WHERE office.office_id=floor.office_id and office.office_name='$office';

SELECT room_name FROM floor,room WHERE floor.floor_id=room.floor_id and floor_name='$floor';