I have two columns: wash score (wash_sc) and agric score (agric_sc). I want to sum both cumulatively and group by month. Currently am able to accomplish this for one variable, though it is takes a long time to return the…
Undefined property: IlluminateDatabaseQueryBuilder::$title public function show(string $id) { $books = DB::table("book_tbls") ->where("author_tbls.id", "=", $id) ->where("author_tbls.id", "=", "book_tbls . author_id") ->where("categories.id", "=", $id) ->where("categories.id", "=", "book_tbls . category_id"); // $books = book_tbl::find($id); return view('books.show', compact('books')); } I am learning laravel for…
Here below is a table that stores a one-to-many relationship where one user might be associated with one or more profiles: +----+---------+------------+------------------------+ | ID | USER_ID | PROFILE_ID | LAST_PROFILE_DATE_TIME | +----+---------+------------+------------------------+ | 1 | 100 | 101 | 04.06.23…
I have table transactions with below details id dt_trans category description amount 1 2022-08-05 Expense Food 60.00 2 2022-08-05 Travel Petrol 20.00 2 2022-08-08 Travel Petrol 20.00 then I want to create report based on below report dt_trans category description…
Im currently working with SQL, and im currently using postgreSQL, sepcifically pgAdmin4. i have this table i called 'acetami' created with the following query: CREATE TABLE ACETAMI ( PRIMARYID BIGINT, DRUG VARCHAR(3000), Gender VARCHAR(3), AGE FLOAT, Adverse_event VARCHAR(100), ROLE_COD VARCHAR(2)…
I have a table in my database with many (10+) int4 columns, and I am also developing an application server which updates these values. My current approach requires multiple round trips, because I do something like this, each as a…
I have a MySQL table which has sets of records that follow a sequence of events. I would like to find out cycle time (time it took to complete) by calculating the difference between few specific set of records. Table…
I have a MySQL database that has a table with multiple duplicate records. The table has 4 columns e.g. id, post_id, post_key and post_value. I am able to return the duplicate entries with the query below. SELECT * FROM table1…
I have a table contain reference time and a user check-in time. Both data is different in type. Sample data dtime = 2023-06-02 08:23:21 work_time = 08:00-18:00 And my code is... SELECT substring(dtime,-8,5) AS chkin, SUBSTRING(work_time, 1, 5) AS wt1,…
I have a called users id name username 1 John user1 2 Mary user2 3 Bucket user3 second table relationship id followerid followId 1 2 1 I want to use sql query to get the user3 not following user1 export…