---
# System prepended metadata

title: <center><i class="fa fa-edit"></i> SQL and Dashboard </center>
tags: [Internship]

---

# <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)
:::

![](https://i.imgur.com/UzJqQLc.png)

```sql=
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';
```
![](https://dawn-manatee-65a.notion.site/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2Fbcd39ee3-a260-49f3-876a-168524be7e83%2FImage_2.png?table=block&id=04b99834-9d0d-498d-a559-f9d013002968&spaceId=3407f007-8aea-45c1-9116-d92821fc2626&width=2000&userId=&cache=v2)

![](https://dawn-manatee-65a.notion.site/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F3ca34ed1-79af-47d6-9ac4-84dff86e7bda%2FImage_4.png?table=block&id=92b50045-90bb-4241-9339-3903de0831d5&spaceId=3407f007-8aea-45c1-9116-d92821fc2626&width=1750&userId=&cache=v2)
