I have two tables: Task: Select last_name of users who: placed at least one order in January 2013; and also made at least one order in any other month of the same year. I can only use subqueries, joins and…
I have 'stock_price_15m' table which stores 15 minute OHLC candlestick data. niftydb=# d stock_price_15m; Table "public.stock_price_15m" Column | Type | Collation | Nullable | Default ----------+--------------------------+-----------+----------+--------- stock_id | integer | | not null | dt | timestamp with time zone…
i want to select row by the highest votecount from a table, but if the userid is repeted i want the just the row with the highest votecount. eg: userId votecount 2 2 2 12 1 20 my result is…
I have a table like this I need to get the validity order by the number of true values in the last 4 columns. For e.g. the output of the below query should be 1110 // 4 true values 1001…
I want to copy a Postgres table in CSV format from a network database to my computer. For example, here is its address psql postgresql://login:[email protected]:5432/test_table The problem is that I don't have superuser rights and I can't copy the table…
I’m using MySQL to make a table: CREATE TABLE school.student( Std_id INT NOT NULL AUTO_INCREMENT, Std_name CHAR(40) NOT NULL, Std_Birth DATE, Std_Group CHAR(2) check(Std_Group in ('G1', 'G2','G3','G4')) ); And I’m trying to make the auto increment start from 1000 and…
i have data which is below has email and working hours (in hours formate), expecting output of working_hours to hh:mm:ss select d.email,TRUNCATE(sum(e.hours),2) as "working_hours" from users d inner join proj_time e on d.id=e.user_id WHERE start_time BETWEEN CURDATE() - INTERVAL 1…
I'm trying to figure out how to select the latest DateTime value in a table and all previous data that came with it in a 30 minute window using MySQL. eg table: DateAndTime --------- 09:00:00 08:59:50 08:59:40 08:59:30 08:59:20 08:59:10…
I have a list of countries, and for each country I have a table like this (first column: user, second column: user_type, third column: date): user user_type date user1 National 2022-10-01 user1 National 2022-10-01 user2 National 2022-10-01 user2 International 2022-10-01…
I have this PostgreSQL table for storing words: CREATE TABLE IF NOT EXISTS words ( id bigint NOT NULL DEFAULT nextval('processed_words_id_seq'::regclass), keyword character varying(300) COLLATE pg_catalog."default", trademark_blacklisted character varying(300) COLLATE pg_catalog."default" ); insert into words (keyword,trademark_blacklisted) VALUES ('while swam is…