vendors | Simple json files for cmder | JSON Processing library

I've joined 2 tables and extract the top 2 vendors by country (code at the bottom of this post and link) with the help of Tim Biegeleisen on this link , now I would like to go 1 step further and group the top 2 vendors by year by country.

The original ORDERS table looks like this :

country_name date_local vendor_id gmv_local is_successful_order Taiwan 2012-10-02 2870 559.6 true Taiwan 2012-10-02 3812 573.5 true Singapore 2012-10-02 941 778.6 true Singapore 2014-10-02 13 120.6 true Bangkok 2014-10-02 227 563.6 true

This table is merged with the vendor table

id vendor_name country_name 2870 C House Taiwan 941 A House Singapore 227 9 House Bangkok

I would like to extract the year from the "date_local" column into timestamp format, where the items in the Year column will look like "2012-01-01T00:00:00" from the original date format of "2012-10-02"

Then I would like to list out the top 2 vendors of by year of each country in total revenue

The resulting table should look like this:

year country_name vendor_name total_gmv 2012-01-01T00:00:00 Singapore A House 1119.76 2012-01-01T00:00:00 Singapore B House 819.63 2012-01-01T00:00:00 Taiwan C House 119.6 2012-01-01T00:00:00 Taiwan D House 119.6 2012-01-01T00:00:00 Bangkok 9 House 119.6 2014-01-01T00:00:00 Singapore A House 2119.76 2014-01-01T00:00:00 Singapore B House 1819.63 2014-01-01T00:00:00 Taiwan C House 1019.6 2014-01-01T00:00:00 Taiwan D House 919.6 2014-01-01T00:00:00 Bangkok 9 House 189.6

printscreen of target results

I know I need to add one more partition of the Extract( year FROM date_local) as year and set it to the correct GETDATE() timestamp format to add the extra layer needed, but I don't know how to add it to the code

...

I am doing a query on Google Big query, I have joined the 2 tables and created a new column "total gmv" using "SUM" to represent the total revenue, now I wanted to show only the top 2 vendors , GROUP BY country in my query.

I manage to show total_gmv group by COUNTRY and vendor_name, but I would like to filter to show top 2 vendors for each country only.

Code I used

...

I'm trying to create Dropdown button using Bootstrap 5, but I'm getting an error: Uncaught TypeError: t.createPopper is not a function

This is my HTML code:

...

I have a class named vendor

...

I have been working on a I/O bound application which is a web crawler for news. I have one file where I start the script which we can call "monitoring.py" and by choosing which news company I want to monitor I add a parameter e.g. monitoring.py --company=sydsvenskan which will then trigger sydsvenskan webcrawling.

What it does is basically this:

scraper.py

...

I am trying to use vuejs-datepicker in a nuxt app, everything is done by nuxt plugin usage standarts.

plugins/vue-datepicker.js

...

I'm trying to make a web page that starts with a image next to some text. I got that to work but when I try to put content under that it works on desktop but when the columns get stacked the content below covers the second column. I don't do a heap of web design so this might be a easy fix.

Here are some images: These images are scrolled down the image fill the whole viewport.

Working on desktop

Not working when stacked

Here is my code:

index.html

...

I m working on an ESP32 project, where I m fetching some array value from a file that is saved in spiffs. After fetching the value in sending the raw value of IR using IRsend function and after that sending MQTT acknowledgement to aws. But at publishing time I m getting the error stack overflow error. Sending the acknowledgement

...

I'm new in react and storybook and here is the problem : my todo component is like this:

...