I have a query which first performs joins inside cte and then based on cte join with other table and perform group by with some aggregations and get the top 15 records. WITH join_table as ( SELECT pl.yearmonth, pl.pdid, pl.OrderId,…
so I am trying to update the JSON file using this particular query, but everytime i run this, it throws the error and my database isnot updated. cursor = connection.cursor() updated_data = { "Name": "John", "Age": "53", "SSN": "374875430" }…
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…
I have a postgresql database with four tables: User, Country, City, and Street. The User table contains information about users, including their name, level (which can be "Country", "City", or "Street"), and ids that corresponds to the ID of the…
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'm trying to put sequence id which should start from current date then backwards and should only limit up until 5 rows. I can't do by date as there are times there are missing date row so I still have…
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…
My code doesn't work , i do some searching and try to wrap the code together <?php $del = mysqli_query($con,"DELETE FROM tb_absen_mingguan WHERE tanggal=$_GET[tanggal] <= CURRENT_DATE - INTERVAL 7 DAY;"); if ($del) { echo " <script> alert('Data telah dihapus !');…
I am trying some practice SQL problems and I am having trouble with one question. The question wants me to return a table that has [Test ID, Test Name, and Test Difficulty]. The issue is that I have to create…