I have the following JSON structure and have it parsing into 3 tables (appointment, dock, warehouse). When all the JSON data is valid all records can be parsed at once very quickly. When there is a data issue (with just…
With this query: with tbl as ( select 1 ord, 'A' name from dual union all select 2 ord, 'A' name from dual union all select 3 ord, 'A' name from dual union all select 4 ord, 'B' name from…
I am trying to join 2 tables via 2 columns however, the left tables has entity values after them that I want to discard and they always start with (. Example: 1256390(1) or 23452(9), I need to disregard the (1)…
In the nobel quiz, there is a question "Write the code which would show the year when neither a Physics or Chemistry award was given'. My code is as following: SELECT yr FROM nobel WHERE subject NOT IN ('Chemistry','Physics') The…
Using jOOQ and PostgreSQL, is there a way to know what operation was executed for a MERGE, INSERT or UPDATE? E.g. using the example from jOOQ's documentation: create.mergeInto(AUTHOR) .using(create.selectOne()) // Suppose the last name is unique (natural key) in my…
I have a table with the lat & lng for two points: CREATE TABLE location_pairs ( lat_1 float, lng_1 float, lat_2 float, lng_2 float ); I also have a function that takes two lat/lng coordinates pairs and returns a table…
I want to get the list of users who are new users vs returning user. Report is taken for every week. If user logs in for the first time in a week he is considered as new user,in a week…
My SQL knowledge is really basic, and need some help in translating this rather long query (running in a python script querying some AWS athena database, with some f-strings embedded) to plain English or flow chart. I understand concepts of…
My table looks like this: CREATE TABLE `character_unique` ( `id` int(11) NOT NULL, `name` varchar(256) NOT NULL, `category` varchar(64) DEFAULT NULL, `name_without_stop_words` varchar(320) DEFAULT NULL, `name_first_word_with_exception` varchar(320) DEFAULT NULL, `master` varchar(320) DEFAULT NULL, `nb_letter` int(11) DEFAULT NULL, `count` int(11) DEFAULT…
I'm a my SQL beginner, I need to know how to display the results from 3 queries that are different in row-count. They'll be querying the same table. Example table: Scores NAME | SCORE jack | 1 mike | 3…