I have data with a frequency of one minute for 3 years and I would need to put it in one table to make it comparable. Table1-2019 date_time v_2020 01.01.2019 01:00:00 50 01.01.2019 01:01:00 49 01.01.2019 01:02:00 56 Table2-2020 date_time…
I have 3 tables vendors, components and catalog, here is the schema: vendors - vid,vaddress,vname components- cid, cname, type catalog- cid, vid, cost catalog is connected with the 2 tables with a foreign key vid and cid. Query: select vid…
Departemen = 'nama_departemen', 'nama_manager', 'jumlah_pegawai', Pegawai = 'nomor_induk_pegawai', 'nama_pegawai', 'id_departemen', 'email', 'telepon', 'gender', 'status' PegawaiController public function index() { $pegawai = Pegawai::Join('departemens','pegawais.id_departemen','=','departemens.id')->paginate(5); return view ('pegawai.index', compact('pegawai')); } public function destroy($id) { Pegawai::find($id)->delete(); return redirect()->route('pegawai.index')->with(['success'=> 'Item Berhasil Dihapus']); } public function…
MySql issue: I want to extract the two best age_groups per region based on their wins. I haven't had much luck on this, having browsed similar issues. It's probably straightforward but mysql isn't playing nice for me this evening. region…
I'll give an example to better clarify what I want: Suppose I have the following classes in my programming language: Class Person( int id, string name, List<Car> cars ); Class Car( int id, string name, string brand ) I want…
I had to get the town name and state from database which deployed the first reciever(a device to sense sharks). I used the following query with a subquery computing MIN of deployed dates: SELECT t.town,t.state,r.deployed FROM receiver as r inner…
I've got 3 tables I need to work with: CREATE TABLE invoices ( id INTEGER, number VARCHAR(256) ) CREATE TABLE items ( invoice_id INTEGER, total DECIMAL ) CREATE TABLE payments ( invoice_id INTEGER, total DECIMAL ) I need a result…
I'm trying to create the most optimal query where the database would return the names of readers who often borrow sci-fi books. That's what I'm trying to optimize: SELECT reader.name, COUNT (CASE WHEN book.status_id = 1 AND book.category_id = 2…
I swear I tried everything I could but with no success, I read every answer in the whole platform but I can't get rid of duplicates (or loop repetitions) My tables are: items item_id (primary, AI, unique), it_title, etc. (the…
I got 3 tables | ID | Name | |:---- |:------:| | 1 | Brie | | 2 | Ray | | 3 | James | Table2 | ID | Q_id | Q_no | ans | |:---- |:------:| -----:|----:| |…