How To GET URL of All Multi Websites & Stores in Magento 2.x by Using SQL Query

There are following below two SQL Queries, we can find All Multi Websites and All Multi Stores.

[1] – To Get All Multi Websites

The follow below SQL Query to run

SELECT * FROM core_config_data WHERE path in ("web/unsecure/base_url", "web/secure/base_url");

Once run above command, below main website & other websites result

[2] – To Get All Multi Stores

SELECT * FROM core_config_data WHERE path in ("web/unsecure/base_url", "web/secure/base_url");

Once run above command, below main website & other stores result