Query Data in Google Sheets with SQL

未关闭
#6 1 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看

还没有人认领这个 Issue。

评估

难度
1/5
预计耗时
1-3 小时
新手友好度
45/100
Issue 类型
文档
描述清晰度
描述清楚
活跃度
停滞
技术栈
sql
领域
content, documentation

调研方向

没有提到 repository 文件或测试。先从 Google Sheets 视频中链接的 SQL 和提供的数据集开始，然后跟着查询执行 GROUP BY 和聚合。完成工作的标准是在你自己的 Google Sheet 中完成工作，并在你对 ticket 的副本中提交一个清晰可读的共享链接。

由索引模型根据 Issue 内容生成。

描述

🏕 Priority Mandatory 🐂 Size Medium 📅 Sprint 3 Core Module-Onboarding Submit: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
  1. Combine both of these sheets into one. You can create a new sheet for each piece of work.
  2. 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

贡献指南

打开贡献指南

从这里开始

  1. 先读完整个 Issue，再读项目的贡献指南。
  2. 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
  3. Fork 仓库，在一个分支上完成修改。
  4. 提交 Pull Request，并在描述里引用这个 Issue 编号。

CodeYourFuture/Module-JavaScript-Fundamentals 的其他 Issue

查看 CodeYourFuture/Module-JavaScript-Fundamentals 的全部 Issue

相似的 Issue

更多 JavaScript Issue

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。