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
-
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