MySQL How LIKE 1 digit
I have this records: Number 1, 2 1, 24 How to select only 2 by LIKE not 2 and 24 SELECT * FROM test WHERE number LIKE '%2%' 1, 2 // need only this record 1, 24
How to show username if i have 2 tables, user and review – Mysql
i am creating a restaurant review website. in my review table i have a foreign key called user_id and idk how to use it to display the username which is in the user table my user table my review table…
Deleting a file from S3 does not delete it from Athena?
When I add a file to S3, run a query against Athena, Athena returns the expected result with the data from this file. Now if I then delete that same file from S3 and run the same query, Athena still…
Create date-aggregate statistics of product sales and prices in plain SQL – Postgresql
I have the following two tables: CREATE TABLE products ( id INT, created_at DATE, sold_at DATE ); CREATE TABLE product_prices ( id INT, product_id INT, price numeric, created_at DATE ); The data model logic works as follows: When a new…
MySQL select statement with tablename derived from database query
I want to write a SELECT statement, where the tablename is based on the response to a different SELECT query. I can't use stacked queries, and I can only use MySQL. As pseudo-code, this is what I'd like to do:…
How to weight cols for each records using SQL only – Postgresql
In Postgresql, suppose I have a 2-col table containing 3 records, namely tA id | col_A | col_B | type 1 | 1 | 2 | A 2 | 3 | 4 | B 3 | 3 | 1 |…
Unable to access column alias in WHERE clause – Postgresql
I am trying to filter rows from my Postgres database with below query. Everything works fine but when I try to check if latesttask column is null or has some value then it shows error: error: column "latesttask" does not…
sum greater than in subquery – Postgresql
I'm making a database in PostgreSQL that involves around democracy. All data that should be displayed are controlled by the users, and their percentage of power. I'm struggling to write this SQL query where a collection of tags on a…
How to enforce a uniqueness constraint in a SQL database based on a certain condition – Postgresql
I'm working on a SQL database, and I have the following table: Workout Routine id serial PRIMARY KEY, user_id integer REFERENCES users (id) ON DELETE CASCADE NOT NULL, name varchar(255) NOT NULL, active boolean DEFAULT TRUE, UNIQUE(user_id, name) Currently, the…
SELECT without FROM clause cannot use aggregation – Mysql
I am trying to get the average ride length duration for casual and member riders from the dataset "all_year" and list it as average_trip_duration_all_year Code I am trying to run: SELECT member_casual, CASE WHEN member_casual = 'member' THEN (SELECT AVG(ended_at…