I am learning SQL and have created the following dataset in MySQL: Create table Departments (DepartmentID int primary key, Name text); insert into Departments values (1001,'SRO'), (2001,'Drs'), (3001,'Accounting'); Create table Employees ( EmployeeID int not null, DepartmentID int not null,…
I have a table where we have partners and orders are set. |partner_id|order_id| | -------- | ------ | |1 |5 | |1 |6 | |2 |7 | |4 |8 | |4 |9 | |4 |10 | Here we have a…
My objective is to make Postgres choose a faster plan after a large table update. Before the table update, the plan PG choose is what I expect (the faster plan). However, after the update, PG chooses a slower plan (it…
[TABLE 1] shop_name whole_sales_amount A 20000 B 40000 [TABLE 2] shop_name locataion representative_number A NY 1234 A LA 1234 B IL 5678 I want to join Table 1 & Table 2 (I know that the DB table structure is not…
Suppose, we've a table named college. In this database we've the following columns: College ID, College name, State and Established in. Now I want to find the names only of those colleges where the college have another branch in the…
can anybody help? there's a table containing data about games...including: name VARCHAR(255) platform VARCHAR(255) year_of_release YEAR genre VARCHAR(255) publisher VARCHAR(255) na_sales DOUBLE(10,2) other_sales DOUBLE(10,2) global_sales DOUBLE(10,2) when i run this query: select Name, Year_of_Release, Other_Sales, Global_Sales from ( select *…
I have this table, in the left there is the sample input table and on the right desired output How to calculate the number of status per empid basis using SQL on MySQL.
I have a table like this in Postgres: user_id project status 1 p1 finished 2 p1 finished 2 p2 finished 2 p3 finished 3 p1 finished 3 p2 finished 3 p3 finished 4 p1 finished 5 p1 finished 6 p1…
I'm learning SQL and have come across a problem that needs a self-join. I've been playing around with the query to understand why the self-join table lays it out the way it does, but haven't had much luck Create table…
In mySQL, have a large table of history data and I am looking for an elegant way to be able to select the earliest/latest event types in a single select statement without grouping by Item and Event type and running…