rhc2104 / sqlteaching Goto Github PK

View Code? Open in Web Editor NEW

236.0 236.0 50.0 1.22 MB

Home Page: https://www.sqlteaching.com

License: MIT License

CSS 60.45% JavaScript 36.78% HTML 2.77%

sqlteaching's People

Contributors

Stargazers

Watchers

Forkers

tinti michaelrbock nextacademy ravitejadaggupati mshava number0 outofbrain gitter-badger maxchv jaredpowers hzlpy rtbarber iamutkarshtiwari hangyu-feng sh7ne ahmadawais kanglicheng avermeulen ltcrane4 silotto playernato ortodata osvaldojuniorc millennium-software vagnerdesigner felipemonteiro-code rolandstuder mathiasverraes levasseurv robsonamendonca eltonleao venhow aanimesh cbpportfolio ijayabby paulatdunedin evertonldesouza brunogtorres mateusz-piotrowski overlandcoder clairecharles aakash9399 castanto69 darknab jackgraymer hjkl01 souza83 jnunez2301 nileblack

sqlteaching's Issues

Extra level suggestions

Feel free to add extra level suggestions. Please remember that the lessons have to work in SQLite.

Site down

Really apreciate your work. I learn my SQL entirely on your site.
Jut to let you know that the site is down now.

Replace "as" to "AS" in Lesson 31: COALESCE

I think It would be better to replace the example code snippet in Lesson 31: coalesce: From

SELECT name, COALESCE(gun, sword) as weapon FROM fighters;

SELECT name, COALESCE(gun, sword) AS weapon FROM fighters;

For brevities sake and better alignment with Lesson 25: Table alias
and Lesson 26: Column alias

Typo on line 311 in sqlteaching/sqlteaching.js

sqlteaching/sqlteaching.js

Line 311 in 1bd1230

    
           'prompt': 'In the previous exercise, we explained that TV show character names were not duplicated, so if the name of a character were to change, you would only have to change the name of the character in one row. <br/><br/>However, the previous example was a bit artificial because the TV show names and actor names were duplicated. <br/><br/>In order to not duplicate any names, we need to have more tables, and use multiple joins. <br/><br/>We have tables for characters, TV shows, and actors.  Those tables represent things (also known as entities). <br/><br/>In addition those tables, we have the relationship tables <strong>character_tv_show</strong> and <strong>character_actor</strong>, which capture the relationship between two entities. <br/><br/>This is a flexible way of capturing the relationship between different entities, as some TV show characters might be in multiple shows, and some actors are known for playing multiple characters. <br/><br/>To get each character name with his/her TV show name, we can write <br/><code>SELECT character.name, tv_show.name<br/> FROM character <br/>INNER JOIN character_tv_show<br/> ON character.id = character_tv_show.character_id<br/>INNER JOIN tv_show<br/> ON character_tv_show.tv_show_id = tv_show.id;</code><br/><br/>Can you use two joins to pair each character name with the actor who plays them?  Select the columns: <strong>character</strong>.<em>name</em>, <strong>actor</strong>.<em>name</em>'},

"In addition those tables, we have the relationship tables" on line 311 is missing a "to".
It should be "In addition to those tables".

Problem description miss "not" in "Joins with WHERE"

Can you return a list of characters and TV shows that are not named "Willow Rosenberg" and in the show "How I Met Your Mother"?

should be not in the show "HIMYM"

GROUP By

Group By lesson 16 doesn't return expected results.

Fix typo

https://www.sqlteaching.com/#!substr

Small typo on Lesson 30, in this sentence:

"1 would indicate the first character, 2 would indicated the second character"

In that sentence, "2 would indicated" should be changed to "2 would indicate"

I realize this is minor, but I still wanted to contribute. And thanks for the lessons, they're great.

rhc2104 / sqlteaching Goto Github PK

sqlteaching's People

Contributors

Stargazers

Watchers

Forkers

sqlteaching's Issues

Extra level suggestions

Site down

Replace "as" to "AS" in Lesson 31: COALESCE

Typo on line 311 in sqlteaching/sqlteaching.js

Problem description miss "not" in "Joins with WHERE"

GROUP By

Fix typo

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent