I need help with an assignment for school. I've only been doing SQL for 2 months and can't figure this out. My teacher gave me some hints about using self joins. The database has 3 more tables, but I don't…
Suppose a PostgreSQL table, articles, contains two nullable String columns of name and alt_name. Now, I want to find records (rows) in the table that have a combination of String name and alt_name matches another combination of the same type…
https://i.stack.imgur.com/0yDsf.png year month no_of_people avg 2005 1 Overall 8 2005 2 Overall 5.0 2005 3 Overall 2.7 2005 4 Overall 4.1 2005 5 Overall 6.8 2005 6 Overall 5.2 2005 7 Overall 4.7 2005 8 Overall 4.4 2005 9 Overall…
I have a Postgres table that looks like this: Name Type Description business_id (PK) int4 Business ID day (PK) int4 Day of week (0-6, monday is zero) open time Open time close time Close time Every row stores open and…
I need to copy all data from one column customerId to another new column (customerIds - which is in different format) in the same table. There is a column called customerId whose type is bigint and I need to copy…
I have table towns which is main table. This table contains so many rows and it became so 'dirty' (someone inserted 5 milions rows) that I would like to get rid of unused towns. There are 3 referent table that…
I need to join all the three tables as mentioned below datatype id code 1 Q_1 2 Q_2 3 Q_3 4 Q_4 5 Q_5 6 Q_6 7 Q_7 8 Q_8 9 Q_9 10 Q_10 model id datatype_id values model_ex_id 1…
I have data like this: Customer ID Name Type Last Submit 1 Patricio C January 2022 2 Dale A June 2022 3 Yvonne C July 2022 4 Pawe C JUne 2022 5 Sergio B August 2022 6 Roland C August…
EDITED: I am trying to CASE a query from my table when a result meets 2 sets of criteria (Flight Time & Tail Number), but I am receiving the wrong result. I only started SQL a few weeks ago for…
I have a table like sales(product_number, assortment, date) Here 1 assortment contains multiple products. For example 1 assortment i.e. chocolates contains product_number cadbury, 5 star, kitkat etc. Each and every product has date. I'm trying to check that all products…