There is a database with online store customers, which has the following data: id buyer's; order number; date and time of the order; order amount. Data on customers and orders for 3 months. How to withdraw customers who made more…
I'm working on an application where I need to monitor the latest IoT data being sent from a fleet of over 3000+ vehicles. Each vehicle is equipped with an IoT device that sends data to an Iotdata table. To determine…
(sale_id, year) is the primary key (combination of columns with unique values) of this table. product_id is a foreign key (reference column) to Product table. Each row of this table shows a sale on the product product_id in a certain…
I have a MongoDB collection where I have an array of objects and I want to add an incremental index value to each element of the array of objects. Like index starts from 0 to array length - 1. db.collection.aggregate([…
I am attempting to store the name of a MongoDB collection in a variable and refer to that in a query. If I specify the name of the collection without quotes, my query runs, but if I place the name…
I'm trying to get data from "users" table into 'user_id' and 'profile_fullname' rows from "profiles" table. For example if a row has an id of 1 in the "users" table, then the 'user_id' should also be 1. Same with the…
This is my MongoDB aggregate result based on the below aggregate query. { "count": 1, "fields": { "accountCode": "17G00011", "accountName": "GST input Receivable" }, "amount": 94.5 } { "amount": -619.5, "count": 1, "fields": { "accountCode": "21C00005", "accountName": "Cyberview Technologies" }…
I am using CTE to check database rows, delete rows by filtering and finally to insert row into the database. Below is the go function to Insert a row: func (vm VoteModel) Insert(vote *Vote) error { ctx, cancel := context.WithTimeout(context.Background(),…
I have to implement a routine/library to discover an application's APIs then list them in a database. I don't know where to start and I can't find anything really helpful in internet. All I can do is display the API…
I have a question about data performance time value is stored as long in my spring boot application. When I retrieve multiple data, I convert the time using Date_Format FROM_UNIXTIME like below @Query("SELECT new today.feeling.dto.response.emotion.EmotionMonthlyReportQuery(" + "s.id, " + "s.studentId,…