Many times, we need to work on more than 1 tables of data. Means, table one needs to connect with other tables. In SQL, we called it joining. So, on this section, we are going to answer some questions regarding to joining table. So we have tables like below :
Bonus table :
Hi guys, actually this part should be 16 but because yesterday I accidently erased it. So sad because already wrote it perfectly but nothing to do because it’s already gone so just let go it with happy.
Okay guys, so on this moment we are going to continue the exercise on last part. So, below is the table that we have :
Employee table :
Hey everyone, last part about this subject discussed about OPERATORS used in Python. On this chapter, I am going to share about COLLECTIONS in Pyhton.
In Python, there are four collection data types, that is :
Example 1 (creating list) :
Hey guys, how is your day ? I hope each of us have a great day. On this section, as I mentioned in the previous post that after understanding the definition and functions of commands in SQL, we are going to move to practiceable questions as an exercises.
Related to the last section about this topic, I am going to continue to make some questions and answer that on this part. Let’s started :
Hi friends, finally we meet here again after a week I did not post anything here due to work on some urgent and crucial projects. Last section about this topic, we did some exercises. We are going to do exercise as well, but for different cases. Let’s get started :
So, here we are going to learn about how to create table and how to insert data into the created tables. Besides, we are going to answer some questions regarding to the provided tables. Firstly, we are going to create some related tables as shown below :
Write a query…
Hi everyone, how is everything going? Anyway, we already at June and it seems that many of us still work from home, especially we in Indonesia where the virus started to attack us early on last March. But it does not meant that such kind of issue will anticipate us to be productive.
On this part, I am going to share to you about OPERATORS in Python. Popular operator that we know is addition (+), subtraction (-), multiplication (*), and Division (/). But hey, there are more operators beside those that already mentioned.
So OPERATORS are used to perform operations…
Hi guys, on this part and the next parts, we are going to concentrate on exercises because all the important and frequently used commands, operator, clauses in SQL already exposured together. So, let’s jump into the exercise :
Below is a table named “sql_exercise”. The table consists of id, first name, last name and department. Below are some questions that we are going to answer regarding to the provided table :
Thankfully for being able to write here again. Guys, so on this section I am going to share about the usage of INSERT INTO SELECT and CASE in SQL. Let’s discuss it one by one :
The INSERT INTO SELECT statement copies data from one table and inserts it into another table. Important to remember that :
Take a look on the example below :