Query Data in Google Sheets with SQL
還沒有人認領這個 Issue。
評估
- 難度
- 1/5
- 預估耗時
- 1-3 小時
- 新手友好度
- 45/100
- Issue 類型
- 文件
- 描述清晰度
- 描述清楚
- 活躍度
- 停滯
- 技術堆疊
- sql
- 領域
- content, documentation
研究方向
沒有提到 repository 檔案或測試。先從 Google Sheets 影片中連結的 SQL 和提供的資料集開始，然後跟著查詢執行 GROUP BY 和彙總。完成工作的標準是在你自己的 Google Sheet 中完成工作，並在你對 ticket 的副本中提交一個清晰可讀的共用連結。
由索引模型根據 Issue 內容生成。
描述
Link to the coursework
https://www.youtube.com/watch?v=dTNamL30sDg
Why are we doing this?
To learn how to use Google Sheets to store and query data is very useful. SQL is a powerful tool you will regularly come across when working with databases, either as a programmer or in many other data roles.
Watch the video SQL in Google Sheets. Copy the dataset provided in the video and code along with the queries as you go.
Do up to the step GROUP BY clause and aggregation.
We can skip PIVOT, LIMIT and OFFSET for now. You won't need these for the next piece of coursework, but look at them if you're not short on time.
Acceptance criteria
- I have watched the SQL in Google Sheets video and followed along with the instructions in my own Google Sheet.
Maximum time in hours
2
How to get help
Share your blockers in ITP Slack.
How to submit
- Combine both of these sheets into one. You can create a new sheet for each piece of work.
- Share a link to your Google Sheet on your own copy of this ticket. Make sure to give read access to your sheet, you can do this by clicking the "Share" button, then change "Restricted" to "Anyone with the link".
- 主要語言
- JavaScript
- 星號
- 3
- 分支
- 546
- 平均合併
- 9 小時 40 分鐘
- 30 天內合併 PR
- 2
貢獻指南
從這裡開始
- 先讀完整個 Issue，再讀專案的貢獻指南。
- 在 Issue 下留言說明你要接手 —— 這能避免兩個人做同樣的事。
- Fork 儲存庫，在一個分支上完成修改。
- 送出 Pull Request，並在描述裡引用這個 Issue 編號。
CodeYourFuture/Module-JavaScript-Fundamentals 的其他 Issue
-
🏕 Priority Mandatory 📅 Sprint 1 Core Submit:None
難度 1/5 1-3 小時 新手友好度 72/100
-
🏝️ Priority Stretch 📅 Sprint 2 Setup Submit:None 🦔 Size Tiny
難度 1/5 1 小時以內 新手友好度 90/100
-
🏕 Priority Mandatory 🐂 Size Medium 📅 Sprint 1 Core Submit:None
難度 2/5 1-3 小時 新手友好度 78/100
-
NotCoursework
難度 2/5 1-3 小時 新手友好度 65/100
CodeYourFuture/Module-JavaScript-Fundamentals#1224 · 5 則留言 ·
-
🏕 Priority Mandatory 🐇 Size Small 📅 Sprint 2 Core Module-Onboarding Submit:Issue
難度 1/5 1 小時以內 新手友好度 72/100
CodeYourFuture/Module-JavaScript-Fundamentals#4 · 4 則留言 ·
查看 CodeYourFuture/Module-JavaScript-Fundamentals 的全部 Issue
相似的 Issue
-
bug customer-eng Durable Agents Inngest status: needs triage
難度 2/5 1-3 小時 新手友好度 82/100
-
optimization optimization:agents-md-curator
難度 2/5 1-3 小時 新手友好度 75/100
githubnext/gh-aw-cao#13475 ·
-
[BUG]: "Clear All" in Settings doesn't clear the saved analysis, old data comes back after reload 未關閉bug
難度 2/5 1-3 小時 新手友好度 88/100
AOSSIE-Org/OrgExplorer#253 · 1 則留言 ·
-
難度 2/5 1-3 小時 新手友好度 88/100
oxc-project/oxc#26944 ·
-
ai-observability bug team/ai-observability
難度 2/5 1-3 小時 新手友好度 78/100