nekonotsuchi / sql-scratch-capstone-turn-in Goto Github PK
View Code? Open in Web Editor NEWMy SQL capstone project from the Codecadmy SQL Intensive course.
My SQL capstone project from the Codecadmy SQL Intensive course.
COUNT()
function in the first question asking how many campaigns/sources there are: note.ft_attr.utm_source
could be renamed "Sources".Overall, very good job! Your presentation is very well made and demonstrates a clear understanding of how the SQL tables relate to real-world business problems. One area of improvement is to include renamed columns and table aliases to improve readability. But otherwise, you did a great job grasping the importance of both campaign types and conversion rates. Well done!
It's a good idea to rename columns to make the table more readable, especially when you are pulling data from multiple sources or using aggregate commands (like COUNT()
). The syntax for renaming a column is:
SELECT original_column_name AS 'new_column_name'
Here you could it apply it with:
SELECT ft_attr.utm_source AS 'Source',
ft_attr.utm_campaign AS 'Campign',
COUNT(*) AS 'Number of First Touch'
FROM ft_attr
Good work pulling out the distinct sources and campaigns. However, we wanted you to count how many campaigns and sources there were. You can do so with the COUNT()
command:
SELECT COUNT(DISTINCT utm_source)
FROM page_visits;
SELECT COUNT(DISTINCT utm_campaign)
FROM page_visits;
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.