SQL Part 6

SELECT COUNT(*)
FROM ramenratings
SELECT COUNT(stars)
FROM ramenratings
SELECT SUM(stars)
FROM ramenratings
WHERE country = ‘japan’
SELECT MIN(variety)
FROM ramenratings
SELECT *
FROM ramenratings
ORDER BY variety
SELECT country,
COUNT(*),
AVG(stars)
FROM ramenratings
GROUP BY 1
ORDER BY 3 DESC

--

--

--

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

SQL Learning Paths

Flutter MDC Codelabs: Some extra details

CORE design pattern — the way out from overly complicated code

SRE Journey — How to measure the Progress

Polarr’s Data Analytics Stack

Quick Start: Using spaCy for Named Entity Recognition

Fixing MongoServerSelectionError while connecting MongoDB with node.js

Basic CSRF Attack Simulation & Protection with Spring Security

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Htoo Latt

Htoo Latt

More from Medium

All You Need To Know About Hadoop

Why is Chennai densely populated?

Study Smarter, Not Harder for the BOC Exam

Chi-Square Test in Python: Analyzing Enabling Factors of Mental Health at Work