SQL Problems using Google Sheets
还没有人认领这个 Issue。
评估
- 难度
- 1/5
- 预计耗时
- 1 小时以内
- 新手友好度
- 42/100
- Issue 类型
- 文档
- 描述清晰度
- 描述清楚
- 活跃度
- 停滞
- 技术栈
- sql
- 领域
- data, documentation
调研方向
打开链接的 Google Sheets 模板，并检查早期课程作业中使用的数据集。在同一个 Google Sheet 中的新工作表里完成两个 SQL 任务，然后确认拥有链接的任何人都具有该工作表的读取权限，并提交该链接。
由索引模型根据 Issue 内容生成。
描述
Link to the coursework
https://docs.google.com/spreadsheets/d/1zPeHxhKkYmdiqXNhMwhfC1A0o1wI0zNiD5Gsks2SYoc/template/preview
Why are we doing this?
To practice how to use Google Sheets to store and query data. This should make sure we understand the basics of SQL and how to use it to query data.
We're going to practice extracting data from a database, using SQL. We will use the same data set we used in the Learn about Google Sheets coursework.
Please complete the following tasks:
- Emily Smith would like to be able to quickly see how many deals she's made. She only cares about
Deal ValueandExpected Close dateto see when she'll be paid. Create a query that will give only this information. - As the accountant for this business, I need to find out how much we’ve sold in each country to pay our taxes. Deals are only complete when they have the status
"Closed Won", so we should only include those deals. To make the data easier to work with, we can sort them by country. Can you write a query to get this information?
Acceptance criteria
- I have completed both tasks.
- I have added them to a new sheet in my Google sheet I created in the "Learn about Google Sheets" coursework.
Maximum time in hours
1
How to get help
Share your blockers in the ITP Slack.
How to submit
- The work should be in the same Google Sheet as the "Learn about Google Sheets" coursework.
- Share a link to your Google Sheet. 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
-
ai-observability bug team/ai-observability
难度 2/5 1-3 小时 新手友好度 78/100
-
难度 2/5 1-3 小时 新手友好度 68/100
AllTheMods/ATM-10-L#19 ·
-
难度 2/5 1-3 小时 新手友好度 78/100
SignalK/n2k-signalk#345 ·
-
难度 2/5 1-3 小时 新手友好度 84/100
-
难度 1/5 1-3 小时 新手友好度 88/100
JuliaPluto/PlutoPlotly.jl#72 ·