I keep getting this error even though I have pathed it correctly. Can someone help me? Thanks. this is my form action url form method="post" action="/users/" id="archive-form" this is my javascript fetch url fetch("/users/", { this is my urls.py path…
I have three tables in sql order_table (order_id, product_id, amount) products_table (product_id, name, price_usd), all_orders (order_id, customer_id, order_date, total_amount), I would like to produce a sql query which outputs the total revenue for each product by month for the last…
I have a table where I am returning the top 10 products based on a score, simple enough, along with a related product type table: SELECT * FROM products INNER JOIN product_types ON products .product_type_id=product_types.id ORDER BY score DESC LIMIT…
I have multiple many-to-many relationships and i want to filter through them. The models are: State District I attached an screenshot: (https://i.stack.imgur.com/TJPwp.png) States are Alabama and Arizona, Districts are Autaga, Baldwin and Apache When i check Alabama and Arizona the…
Table 1 and sample data:- CREATE TABLE student_p ( ID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, S_id INT UNSIGNED NOT NULL, Points DOUBLE NOT NULL, P_date DATE NOT NULL ); INSERT INTO student_p VALUES (50055, 3330, 45, '2023-11-30'), (50056,…
I have table: t_patients (id is auto_increment) id patient_id created_at 1 100 2023-01-10 2 200 2023-01-11 3 100 2023-01-15 the result need like this: patient_id 1st come 2nd come 3rd come 100 2023-01-10 2023-01-15 x 200 2023-01-11 x x I…
I'm going over a coding assignment, and I'm running into an error I can't solve. I build a database and try to insert tables into it: CREATE TABLE city( city_id INT NOT NULL, city_name VARCHAR(50) NOT NULL, state VARCHAR(20), zip…
I have some columns with PII that I need to share with a coworker. They need to be able to see 50% of the characters and the other 50% should be replaced by Asterisks, but I dont know how to…
In JPA I want to autogenerate an integer primary key where the generation should start from, say, 1000. I'm new to JPA and I have used IDENTITY type earlier to avoid those extra id tables that JPA otherwise generates. I've…
i have some issue with grouping the data in interval of 2 minutes. here is my table data ticker open high low close time APPL 1940 1950 1935 1948 2023-03-20 11:00:00 APPL 1950 1960 1945 1958 2023-03-20 11:01:00 APPL 1960…