Sample Sales Query

Entity Relationship Diagram

This is an example of a week of sales from a cell phone store. I created five .csv files and imported them into DBeaver. The above SQL query is just one example of how an analyst could query this data. This example ranks the total profit sold, shows the total number of items sold, and the average profit per item for each sales representative.

2023 Detroit Area Extortion Counts by Neighborhood

Creating Table

Create Table

CREATE TABLE TestTable (

id INTEGER PRIMARY KEY AUTOINCREMENT,

firstname VARCHAR(255),

lastname VARCHAR(255),

email VARCHAR(255) NOT NULL UNIQUE,

age INT,

gender VARCHAR(255),

dateentered TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL

)

Inserting Values into Table

INSERT INTO TestTable (

firstname,

lastname,

email,

age,

gender

)

VALUES (

'John',

'Johnson',

'johnjohnson@gmail.com',

'29',

'male'

)

Checking Results

SELECT *

FROM TestTable

ADSB SQL Filter for Military Flights

ADS-B Flight Data Top 100

ADSB Flight Data Bottom 250

Powered by

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

Accept