Transit Information Technology: Basic How to Write a Query (Part 2)

SQL stands for Structured Query Language, and it's used when companies have a ton of data that they want to manipulate in an easy and quick way. Your agency stores data in a database, you may need to learn about the type of SQL used to store your data in order to access the data. Not to worry -- you're in the right place to get started!

Before we begin, make sure that you have a table management application that will allow you to simulate a table to practice performing the queries that I offer. We use DB Fiddle for the table simulations. I have presented the tool in the Transit Information Technology: Basic How to Write a Query course. Please use that course if you need to get familiar with DB-Fiddle https://www.db-fiddle.com/ Let's jump right in. Open DB Fiddle.

An alternate tool is SQL Fiddle. http://sqlfiddle.com/ . It has similar features to that of DB Fiddle. I approve the use of this tool if you have issues with DB Fiddle.

I am offering you a table that I have created to insert into your DB Fiddle session. We will use that table for some of the queries found in this course. No need to close your DB Fiddle session after each query. You will lose the table insert. We will use the table over and over again. Look below and find the query that we are using. Copy and Paste this into DB-Fiddle.

CREATE TABLE trackeractionlog (
clientid INT, evtid INT, Bookinglegid INT, clientname VARCHAR(100)
);
INSERT INTO trackeractionlog (clientid,evtid,bookinglegid,clientname) VALUES (1,2243,334945,'GoogleFinland');
INSERT INTO trackeractionlog (clientid,evtid,bookinglegid,clientname) VALUES (2,3321,987239,'PeterNewEngland');