In the last several posts I have been studying Structured Query Language (SQL) in an effort to enhance my skill set. I had been using Kaggle’s BigQuery datasets to accomplish this task. The problem is that the bigquery library must be imported into the program in order to use a BigQuery dataset in a Kaggle Jupyter Notebook.
I wanted to undertake some pure SQL programming because I believe that most employers are going to want a job applicant to be able to program without the use of Python. I found a website that will allow me to practice programming in SQL and decided to try it out. The website can be found here:- https://www.sql-practice.com
I found the practice questions to be quite a good introduction to SQL programming, and 16 of the easy questions, along with their answers are found below. I think it is best to attempt to answer the questions before looking at the answers, and this will help the learner to pick up the language.
Show First name, last name, and gender of patients whose gender is ‘M’.
Select first name and last name of patients who do not have allergies.
