So, i have two tables fahrlehrer(id_f,first name,last name) and fahrschueler(id,first name, last name,id_f). I have the last name of a column in fahrlehrer. now my task is to show the first name and last name of all fahrschueler that have…
create table A { id text, val text } create table B { val0 text, val1 text, val2 text } id and val of table A contain each a large, but discrete number of values in an many-to-many relationship. Sample…
I have a table with records in it. The desire was to find the records that were exactly the same, except for the time of the 2 records have a difference of less than 2 seconds. I created a query…
I am trying to set up a database design with assets which have a number of distinct IDs, for example: CREATE TABLE IF NOT EXISTS assets ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), rl_id INT NOT NULL, unique_id VARCHAR(9) NOT…
given 2 tables: one named foo with a column named vals that holds a jsonb array, e.g. [ "val-1", "val-2", ..., "val-n" ]; and a second table named baz with a column named val that holds a string, e.g. val-k.…
id Plot_name Measurement firmware_revision 1 InboundTraffic1Byte 300 1.5 2 InboundTraffic500Bytes 200 1.5 3 InboundTraffic1000Bytes 100 1.5 4 InboundTraffic1Byte 1.6 5 InboundTraffic500Bytes 200 1.6 6 InboundTraffic1000Bytes 100 1.6 A MySQL database stores measurements from performance tests, and there is a Grafana…
I have 2 table and I would like to get only unique rows from one those tables. On the following example, I need the list of application_id which have no duplicate name. Table appName app_id app_name APP001 a APP002 b…
I am trying to get max(level) and sum(hours) until someone reaches level 5 for the first time. This is my input date level hours 1/1/2021 1 1 1/2/2021 2 1 1/3/2021 2 2 1/4/2021 3 1 1/5/2021 4 1 1/6/2021…
right now im still practice sql. and try to solve challenge on hackkerank but i got some question and problem Here challenge that i take: "THE PADS" link : https://www.hackerrank.com/challenges/the-pads/problem?isFullScreen=true This challenge contains counting the number of people based on…
I want to generate uuid like this e58ed763-928c-4155-bee9-fdbaaadc15f3 when data is inserted into table: CREATE TABLE IF NOT EXISTS bin_lists ( id uuid NOT NULL, bin integer, card_brand character varying(64) COLLATE pg_catalog."default", status character varying(255) COLLATE pg_catalog."default" NOT NULL, CONSTRAINT…