I have a requirement. I need to take count of same tables from two different schema. The required output should be like (see screenshot here) schema table_name count sch1 table1 1000 sch2 table1 500 sch1 table2 3000 sch2 table2 1000…
I have a table with a collection of parts. These parts have an id and a serial number provided by the manufacturer. Parts are put together to build an assembly and the order which the parts are assembled matters. When…
updated I have the following table of updates which you will note contains nulls refer event_date col1 col2 col3 cat 2 today null null bbb a 2 yesterday null null null b 2 yesterday null xyz null b 2 last…
I have a table: user_id type date 1 prime 2022-05-31 1 usual 2022-06-30 1 usual 2022-07-31 1 usual 2022-09-31 I need to get a table grouped by user_id and type and validity period. The main difficulty is that the periods…
We have a table called "subscriptions" that stores information about salon subscriptions. The table has the following columns: subscriptions id, start_date, end_date, subscription_plan_id, salon_id We want to write a query that provides the following information for each month: Date Total…
I have the following table: CREATE TABLE trajectory( user_id int, session_id int, timestamp timestamp with time zone, lat double precision, lon double precision ); INSERT INTO trajectory(user_id, session_id, timestamp, lat, lon) VALUES (1, 25304,'2008-10-23 02:53:04+01', 39.984702, 116.318417), (1, 25304, '2008-10-23…
Supposing there's a portal that shows 10 products on a page. The desired goal is to show up to 3 randomly chosen "is_featured" products on the first page among other products if they exist. If not, show just 10 regular…
I am trying to create a createUser function that should only create a user if no user is found with the chosen username (that is, the user does not exist). Also this function should return a promise that i would…
we are dropping a column using mysql alter command but admin has set ndb_allow_copying_alter_table=OFF recently and now while running the alter query we are getting below error: ERROR 1846 (0A000): Implicit copying alter is not supported. Reason:ndb_allow_copying_alter_table=0. Try ALGORITHM=COPY to…
I have a table with the following structure: +------+--------------+--------------+ | SHOP | BUY_PROFIT | SELL_PROFIT | +------+--------------+--------------+ | A | 10 | 15 | +------+--------------+--------------+ I need to write select statement to make it look like this: +------+------+--------+ | SHOP…