Data Definition I have a status table like so, attributes not relevant to the question are omitted: id created value 1 2024-06-24T13:01:00 error 2 2024-06-24T13:02:00 ok 3 2024-06-24T13:03:00 warning 4 2024-06-24T13:04:00 error 5 2024-06-24T13:05:00 error 6 2024-06-24T13:05:30 error 7 2024-06-24T13:06:00…
I'm studying Employees Sample Database which has the following table. create table dept_emp ( emp_no int not null, dept_no char(4) not null, from_date date not null, to_date date not null, primary key (emp_no, dept_no), constraint dept_emp_ibfk_1 foreign key (emp_no) references…
Please help with self join inside one table by different fields. given table "Items": Used PostgreSQL. I need to get all the values from such table, for which factId = 'urn:fact:drug:170' and factId1 ='urn:fact:drug:171' and factId1.value ='false' and arrayIndexes are…
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…
I have table : CREATE TABLE accounts ( "id" INTEGER, "parrent_account" INTEGER, "merchant_type" VARCHAR(8), "name" VARCHAR(32) ); INSERT INTO accounts ("id", "parrent_account", "merchant_type", "name") VALUES (1, 14056, 'outlet', 'RAA CHA SUKI & BBQ NIPAH MAL'), (2, 14056, 'outlet', 'RAA CHA…
Let's say I have a table with logs. The value of status column may be NULL and I would like to UPDATE this value by copying value from the log for same settingid which have non-NULL status and closest (smaller…
I have a table foo: some_fk some_field some_date_field 1 A 1990-01-01 1 B 1990-01-02 1 C 1990-03-01 1 X 1990-04-01 2 B 1990-01-01 2 B 1990-01-05 2 Z 1991-04-11 2 C 1992-01-01 2 B 1992-02-01 2 Y 1992-03-01 3 C…
I'm trying to understand the logic behind the syntax below. Based on the following question, table and syntax: Write a query that'll identify returning active users. A returning active user is a user that has made a second purchase within…
I'm working on for presence control. The check-in and check-out are 2 difference records in a table It is possible that somebody does not check-out for several days, but should count as present for the particular day person ID -…
I have this MYSQL table (simplified version) with some erased ids: +-----+-------+---------+ | id | name | country | +-----+-------+---------+ | 1 | John | England | | 5 | Emily | USA | | 9 | Joe | USA…