{"page":"\n\n
\n
\n
\n
\n
\n\nVideo\n
\n

\nMaster SQL for Data Analysis - Grouping Rows (GROUP BY and HAVING)\n

\n
\n
\nGet Free Access for 10 Days!\n
\n
\n
\n
\n
\n
×
\n\n\n
\n\nPublisher:\n\nCurated Video\n\n\n
\n
\nLet's learn how to group rows based on values in specific columns and then apply different actions on the groups, such as applying filters using GROUP BY and HAVING. This clip is from the chapter \"SQL - Retrieving Data with Queries\" of...\nLet's learn how to group rows based on values in specific columns and then apply different actions on the groups, such as applying filters using GROUP BY and HAVING.

This clip is from the chapter \"SQL - Retrieving Data with Queries\" of the series \"Master SQL for Data Analysis\".This section focuses on the available options to analyze data using sequential query language, filters, aliases, distinct values, grouping rows, datatype conversion, and the database dictionary.\n
\n
\n\n
\n
\n
\n
\n

Resource Details

\n
\n
\n
\n
Curator Rating
\n
\n
\n
\n
\n
\n
Educator Rating
Not yet Rated
\n
\n
\n
\n
\n
Media Length
\n
9:49
\n
\n
\n
\n
\n
Grade
Higher Ed
\n
\n
\n
\n
\n
Subjects
STEM
3 more...
\n
\n
\n
\n
\n
Media Type
Instructional Videos
\n
\n
\n
\n
\n
Source:
\n
\nPackt - Data\n\n
\n
\n
\n
\n
\n
Date
\n
2023
\n
\n
\n
\n
\n\n
Language
English
\n
\n
\n
\n
\n
Audiences
For Teacher Use
2 more...
\n
\n
\n
\n
\n
Usage Permissions
Fine Print: Educational Use
\n
\n
\n
\n
\n
\n

Additional Materials

\n
\n\nSign in or Join Now
\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" href=\"/subscription/new\">Video Transcript\n
\n
\n\nSign in or Join Now
\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" href=\"/subscription/new\">Video Preview\n
\n
\n
\n

Concepts

\n
\n
tables
\n
\n\n\n
\n
\n
\n
\n

Additional Tags

\n
\n
recommender systems, two-tower model, tensorflow, neural network models, neural collaborative filtering, variational autoencoders, amazon product recommendation system, foreign key, title type, title id, aggregated functions, multiple columns, final output, titles table, select section, title, rows, order, section, columns, select, count, column, conditions, option, table, netflixcredits, role, information, execution, output, statement, group, number, important, query
\n
\n\n\n
\n
\n
\n
\n

Classroom Considerations

\n
Best For: Explaining a topic
Video is ad-free
\n
\n
\n

Educator Ratings

\n
\n
\n
\n
\n
\n\nShow resource details\n
\n
\n\" data-title=\"Get Full Access\" data-container=\"body\" rel=\"popover\" tabindex=\"0\" aria-label=\"Play video: Master SQL for Data Analysis - Grouping Rows (GROUP BY and HAVING)\" href=\"/subscription/new\">\"Master\n\n
\n
\n
\n\n\n\n"}