What did I do wrong on this challenge? I can't figure it out. It asked me SUM up the minutes across all todo tasks. CREATE TABLE todo_list (id INTEGER PRIMARY KEY, item TEXT, minutes INTEGER); INSERT INTO todo_list VALUES (1, "Wash the dishes", 15); INSERT INTO todo_list VALUES (2, "vacuuming", 20); INSERT INTO todo_list VALUES (3, "Learn some stuff on KA", 30); INSERT INTO todo_list VALUES (4, "Make bed", 5); SELECT item, SUM(minutes) FROM todo_list;

just exclude the item from your query then you are good to go: SELECT SUM(minutes) FROM todo_list;

Does anyone know what the airline acronym stood for?

The airplane company was Hawker Siddeley. I couldn't find anything on their trademark SEQUEL, but I'm not sure if it was actually an acronym. It could just be the word.

Does anyone know of a good tutorial that would help build a "Hello World" website, that goes through the SQL database setup and procedures to serve content from the database to HTML? I've got LAMP up and running, and have a solid understanding of JS, HTML, CSS, introductory knowledge of PHP and SQL, but I want to pull it all together.

A good starter project would be to use the PHP `mysqli` object (http://php.net/manual/en/book.mysqli.php) to connect to a MySQL database and output the data from the database as a table. Then, as you learn more, you can add ways for users to interact with this data.

Is this course more close to Oracle MySQL, or MS SQL? Or,maybe, there isn't much of a difference?

What is taught in this course (SELECT FROM, INSERT INTO, WHERE, ORDER BY, SUM) is exactly the same in all: SQLite, Oracle SQL, MySQL, MS SQL, differences come later in more complex functions, data types, privileges, joining tables etc... http://docs.oracle.com/cd/E12151_01/doc.150/e12155/oracle_mysql_compared.htm#i1027526

how do I select two different colum headings in _Select * from name_ what would I replace star with.

Good question! I went back to the preceding videos and could not find an example. To get individual columns, just list the column names that you want with commas between them. Using the `groceries` table from the "Querying the Table" video (https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/pt/querying-the-table): We have the `groceries` table with the columns `id`, `name`, `quantity`, and `aisle`. If we wanted just the name of the item and the aisle where we can find it, we would write `SELECT name, aisle FROM groceries;` If we want to know how much of each item we have (a very common query), we could write: `SELECT name, quantity FROM groceries;`

Is a sequel also the second part of a movie?

Sequel refers to the second part of something, not just a movie

Hi why do we have to do this!?

Unless you are taking these courses for school, you are not obligated to complete any of the KACP lessons, challenges, or projects. If you are taking these courses for school, this sounds like a question for your teacher.

On a resume, in USA, would I say "proficient in SQL" or "...SEQUEL"

you would always write "SQL" but when you say it out loud, you have the choice between "sequel" or "S-Q-L" i say "S-Q-L" myself

Main content

Computer programming

Unit 3: Lesson 1

SQL basics

S-Q-L or SEQUEL?

Name: S-Q-L or SEQUEL?
Uploaded: 2015-05-11T01:19:25Z
Description: How is it pronounced? Why? Let's discuss...

Google Classroom

How is it pronounced? Why? Let's discuss...

Sort by:

Want to join the conversation?

keithia.kirkaldy
Posted 6 years ago. Direct link to keithia.kirkaldy's post “What did I do wrong on th...”
What did I do wrong on this challenge? I can't figure it out. It asked me SUM up the minutes across all todo tasks.

CREATE TABLE todo_list (id INTEGER PRIMARY KEY, item TEXT, minutes INTEGER);
INSERT INTO todo_list VALUES (1, "Wash the dishes", 15);
INSERT INTO todo_list VALUES (2, "vacuuming", 20);
INSERT INTO todo_list VALUES (3, "Learn some stuff on KA", 30);
INSERT INTO todo_list VALUES (4, "Make bed", 5);
SELECT item, SUM(minutes) FROM todo_list;
(27 votes)
Answer
- GRanngogo
  Posted 6 years ago. Direct link to GRanngogo's post “just exclude the item fro...”
  just exclude the item from your query then you are good to go: SELECT SUM(minutes) FROM todo_list;
  (75 votes)
Jared Trout
Posted 7 years ago. Direct link to Jared Trout's post “Does anyone know what the...”
Does anyone know what the airline acronym stood for?
(9 votes)
Answer
- Dalendrion
  Posted 7 years ago. Direct link to Dalendrion's post “The airplane company was ...”
  The airplane company was Hawker Siddeley.
  I couldn't find anything on their trademark SEQUEL, but I'm not sure if it was actually an acronym. It could just be the word.
  (20 votes)
Sokrates Anastasiou
Posted 7 years ago. Direct link to Sokrates Anastasiou's post “Is this course more close...”
Is this course more close to Oracle MySQL, or MS SQL? Or,maybe, there isn't much of a difference?
(3 votes)
Answer
- Miodrag Krstic
  Posted 6 years ago. Direct link to Miodrag Krstic's post “What is taught in this co...”
  What is taught in this course (SELECT FROM, INSERT INTO, WHERE, ORDER BY, SUM) is exactly the same in all: SQLite, Oracle SQL, MySQL, MS SQL, differences come later in more complex functions, data types, privileges, joining tables etc... http://docs.oracle.com/cd/E12151_01/doc.150/e12155/oracle_mysql_compared.htm#i1027526
  (27 votes)
Matthew Dowell
Posted 6 years ago. Direct link to Matthew Dowell's post “Does anyone know of a goo...”
Does anyone know of a good tutorial that would help build a "Hello World" website, that goes through the SQL database setup and procedures to serve content from the database to HTML? I've got LAMP up and running, and have a solid understanding of JS, HTML, CSS, introductory knowledge of PHP and SQL, but I want to pull it all together.
(7 votes)
Answer
- budster the dingo
  Posted 6 years ago. Direct link to budster the dingo's post “A good starter project wo...”
  A good starter project would be to use the PHP mysqli object (http://php.net/manual/en/book.mysqli.php) to connect to a MySQL database and output the data from the database as a table. Then, as you learn more, you can add ways for users to interact with this data.
  (9 votes)
Fort Pudgy
Posted 3 years ago. Direct link to Fort Pudgy's post “how do I select two diffe...”
how do I select two different colum headings in
Select * from name
what would I replace star with.
(3 votes)
Answer
- AD Baker
  Posted 3 years ago. Direct link to AD Baker's post “Good question! I went ba...”
  Good question! I went back to the preceding videos and could not find an example. To get individual columns, just list the column names that you want with commas between them.
  
  Using the groceries table from the "Querying the Table" video (https://www.khanacademy.org/computing/computer-programming/sql/sql-basics/pt/querying-the-table):
  
  We have the groceries table with the columns id,
  name, quantity, and aisle.
  
  If we wanted just the name of the item and the aisle where we can find it, we would write
  
  SELECT name, aisle FROM groceries;
  
  If we want to know how much of each item we have (a very common query), we could write:
  
  SELECT name, quantity FROM groceries;
  (9 votes)
Caelan Kort
Posted 2 years ago. Direct link to Caelan Kort's post “Is a sequel also the seco...”
Is a sequel also the second part of a movie?
(2 votes)
Answer
- Wyatt-Matthews(BIO)
  Posted 2 years ago. Direct link to Wyatt-Matthews(BIO)'s post “Sequel refers to the seco...”
  Sequel refers to the second part of something, not just a movie
  (3 votes)
26gmoore
Posted 2 years ago. Direct link to 26gmoore's post “Hi why do we have to do t...”
Hi why do we have to do this!?
(2 votes)
Answer
- AD Baker
  Posted 2 years ago. Direct link to AD Baker's post “Unless you are taking the...”
  Unless you are taking these courses for school, you are not obligated to complete any of the KACP lessons, challenges, or projects.
  
  If you are taking these courses for school, this sounds like a question for your teacher.
  (2 votes)
elijose525
Posted 6 years ago. Direct link to elijose525's post “i want ti known the impor...”
i want ti known the importance of SQL
(2 votes)
Answer
- G.J.
  Posted 5 years ago. Direct link to G.J.'s post “There are many jobs that ...”
  There are many jobs that use SQL as their primary language. SQL is a programming language you can use for many different things besides finding data quickly (say you are a programmer who is trying to find data on a website, about users like those with social media, banking. Some security jobs also use SQL servers to make sure everything works out. This is the basic stuff, when you get into the more in-depth stuff in SQL, you get to learn lots more and cooler things that will help you detect if something is wrong or how to make things better. You could even use this in statistics, I would think! It'd make your job a ton easier if you are dealing with large amounts of data.
  (1 vote)
beebelara1
Posted a month ago. Direct link to beebelara1's post “On a resume, in USA, woul...”
On a resume, in USA, would I say "proficient in SQL" or "...SEQUEL"
(1 vote)
Answer
- mariofan2468
  Posted a month ago. Direct link to mariofan2468's post “you would always write "S...”
  you would always write "SQL"
  but when you say it out loud, you have the choice between "sequel" or "S-Q-L"
  i say "S-Q-L" myself
  (2 votes)
Avish.priya
Posted 6 years ago. Direct link to Avish.priya's post “Who's talking about SQL t...”
Who's talking about SQL the topic?
(3 votes)
Answer
- JustAGuy
  Posted 3 years ago. Direct link to JustAGuy's post “You can pronounce it, eit...”
  You can pronounce it, either way, SEQUEL or SQL this is covered at
  0:01
  in the video.
  (0 votes)

Video transcript

At this point, you've probably heard me pronounce SQL two ways-- sequel or S-Q-L. Some of you might even be mad that I'm pronouncing it one way or the other, and you may have very good reason for believing that your favorite pronunciation is the correct one. So what's the deal? Well, SQL was originally invented at IBM in the early 1970s. And the first version was called SEQUEL, and it stood for Structured English QUEry Language. That acronym, SEQUEL, was later changed to SQL, because SEQUEL was already trademarked by an airplane company, and companies really don't like getting into trademark lawsuits. Nowadays, many of us still pronounce it sequel, because it's shorter to say, and we've got historical reasons to claim that it's the right way. However, when I surveyed developers across the world, I found that in non-English languages, many of them pronounce it S-Q-L, or, for example, ese cu ele in Spanish. Since our videos get translated here on Khan Academy, I figured I'd make it easier for translators to match the pace of our videos, by pronouncing SQL the long way. But in everyday life, I'm used to calling it sequel, so both of them come out of me. Now you know, it can be S-Q-L or sequel, and you'll probably hear both the rest of your life. The world is a messy place, but at least you now have a way of structuring your queries about it, right?

Creative Commons Attribution/Non-Commercial/Share-Alike Video on YouTube