---
# System prepended metadata

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

---

# <center><i class="fa fa-edit"></i> SQL and Dashboard Cont.</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/Kw6Fd5V.png)

```SQL=
SELECT
  time AS "TIMESTAMP", office.office_name AS "OFFICE", floor.floor_name AS "FLOOR", room.room_name AS "ROOM", data.temp AS "TEMPERATURE", data.humi AS "HUMIDITY"
FROM
  office, floor, room, data
where
  office.office_id = floor.office_id and floor.floor_id = room.floor_id and room.room_id = data.room_id and
  office.office_name  = '$office' and floor.floor_name = '$floor' and room.room_name = '$room'
```
![](https://i.imgur.com/TKAZnX9.png)

```SQL=
SELECT
  data.temp AS "Temperature"
FROM
  data,room,floor,office
WHERE
  data.room_id = room.room_id and room.floor_id = floor.floor_id and floor.office_id = office.office_id and
  office.office_name = '$office' and floor.floor_name = '$floor' and room.room_name = '$room'
```
![](https://i.imgur.com/ohVmeFC.png)

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