SQL Code Coach

Question

I’ve been trying some of the Code Coaches, and I found a drop down for a certain programming language. (Like seeing what challenges can be solved in python or ruby) Then, I realized there are no Code Coaches in SQL. Will that be added in a new update or just won’t happen?

Answer 1

Trey
I believe you read my code bits already because you liked it.

https://code.sololearn.com/cKqm1J8dX791/?ref=app

You can use it to practice your SQL skills even you don't have python knowledge.
Write your SQL inside variable and hit run to test your skill.
It is best to view on PC with table_mode on.
You can read the instructions section for more information.

Answer 2

Trey most likely will not happen as sql backend development is very costly compared to regular languages.

Answer 3

Trey
You can always create a form of a database within the playground based around multiple Tables, Arrays, or Directories, or List and give the inputs similar cmd(s) like from table employees

SELECT name, salary
FROM employees
WHERE...
and so as previous users have in the past...

I know I have a project similar in one of my older codes like 3 to 5 years ago.

Very sql oriented and I kept updating it to include more cmd structures and joining tables ...

I wish I could give you a better answer other than an idea toward multiple skillsets.

Answer 4

Wong Hei Ming you did exactly as I mentioned to him to create a database and play around with the cmd(s). Thank you for adding the demonstration code as an example.

Answer 5

Trey
Looks like you are not fully satisfied about our answers.
SQL is very different from other languages. It is specially designed for rational database. The main purpose is to store and retrieve data, while other languages is to solve a problem or perform some action. That's why I don't think code coach will have any challenges about SQL soon.

Meanwhile you can use my code to practice. You need to think some questions for you own.
Here are some of them I makeup quick.
1. Retrieve movie(s) name where a person is a performer and director. And show which character that person is playing.
2. A movie can have more than one category. Find the average number of categories for all the movies / collection.
3. Update the missing data (null) with a actual value you can find.
4. Fully insert a new movie with all the attributes, key players and director.
There can be much more to practice. Be creative.

Answer 6

Well I already completed all the lessons for SQL, and I want to practice my skills from a Code Coach or something.

Answer 7

Ok

Answer 8

Alright then