So I have two tables: CREATE TABLE table1 (`PRIMARY_DT` date, `CUST_ID` int) ; INSERT INTO table1 (`PRIMARY_DT`, `CUST_ID`) VALUES ('2012-03-02', 878 ), ('2012-07-02', 456 ), ('2012-09-02', 789 ) ; CREATE TABLE table2 (`dt` date, `CUST_ID` int, `value` int) ; INSERT…
I have this following query that needs to be optimized Select 1 As status, e.entity_id, e.attribute_set_id, e.type_id, e.created_at, e.updated_at, e.sku, e.name, e.short_description, e.image, e.small_image, e.thumbnail, e.url_key, e.free, e.number_of_downloads, e.sentence1, e.url_path From catalog_product_flat_1 As e Inner Join catalog_category_product_index_store1 As cat_index On…
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…