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 :


image source : codepolitan.com

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 :

  • List : a collection which is ordered and can be changed. It allows duplicate members.
  • Tuple : a collection which is ordered and unchangeable. It allows duplicate members.
  • Set : a collection which is unordered and unindexed. Duplicate members are allowed
  • Dictionary : a collection which is unordered, changeable and indexed. No duplicate members.

List

Example 1 (creating list) :


image source : allvectorlogo.com

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 :

  1. Write a query to order the employee ranging from biggest to smallest- salary

Input :


image source : allvectorlogo.com

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…


image source : allvectorlogo.com

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 :


image resource : udemy

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 :

  • INSERT INTO SELECT requires that data types in source and target tables match
  • The existing records in the target table are unaffected

Take a look on the example below :

Input :

Kristina Paseru

Love to explore new things

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