Wanted to write a SQL query to get unique ids which has 80 marks in Maths and 70 Marks in English and Total Marks is >= 400. Ans would be id - 1 and 2. ID Subject Marks 1 Maths…
I have a table with two fields. The 1st is a 'key' and the 2nd field can have only value 'A' or 'B'. I would like, with a SELECT, to retrieve a recordset that, grouping by the 1st field, have…
Here's my query: SELECT n.id, n.member_id, n.content, n.created_at FROM notes n JOIN note_metadata nm ON n.id = nm.note_id AND nm.meta_key_id = 4 # Nature AND nm.meta_value = 'Cancellation' #ORDER BY n.id DESC LIMIT 10; Without the ORDER BY the query…
I have a database with order_date, product code, and customer like the example here: Index code customer order_date 1 CCC C 2018-01-01 2 AAA A 2020-01-01 3 CCC C 2021-02-02 4 CCC C 2021-03-03 5 DDD A 2022-04-04 6 FFF…
I have created two tables, animation_companies and cartoon_characters. I am given a "document to simulate a request from a supervisor to insert information into a database I have created. The data reads as follows: The Animation_Companies table will contain only…
I have an enum called ProfileType and in MySQL it is stored as an enum like this: The problem is that once I try to login it crashes giving me a "specified cast is not valid" which happens when instatiating…
I'm new to stackoverflow, so in case of any error of formatting, or whatsoever, please let me know. I'm a newbie in SQL so please bare with me. I have two tables: CREATE TABLE Users ( idUser INT NOT NULL…
I'm not able to quite figure out how to capture the changes over time. I have the following: db<>fiddle CREATE TABLE term_changes (load_id int, merchant_id int, load_date date, terms varchar(50)); INSERT INTO term_changes (load_id, merchant_id, load_date, terms) VALUES (1, 1,…
I have an array type column subscription in my table with columns Sample Table +-------+--------+----+----------+ |user_id| Subscription|Activity | +-------+-------------+----------+ |111 |[A,C,B] |20 | |-------+-------------+----------+ |222 |[C,A] |10 | |-------+-------------+----------+ |333 |[B] | 5 | +-------+-------------+----------+ I want to change my…
I have a list of sensitive fields that needs to encrypted before inserting into my MySQL tables, and decrypt them post retrieving it. I thought of the following ways to implement this. Implement a DATABASE Trigger that will encrypt/decrypt the…