---
title: "Using the SQL macro with Markup - 9.x and earlier"
canonical: "https://support.appfire.com/space/SUPPORT/89137701/Using%20the%20SQL%20macro%20with%20Markup%20-%209.x%20and%20earlier"
format: markdown
---
# Scenario
> Macro (div)
>
> > Macro (inline-media-image)
>
> Estimated Time: 8** min**
In this scenario, let's insert the *SQL* macro on a Confluence page by inserting [Markup](https://confluence.atlassian.com/doc/confluence-wiki-markup-251003035.html) from the menu. The *SQL* macro uses the SQL statement loaded into the body of the macro.
## Background
This scenario uses a data source profile, *BookWarehouse,* to query a database table, *PUBLISHERS*. The table contains the following columns and rows:
```sql
SQL > select * from publishers;
+----+------+-------------------+-----------------+---------+
| id | rank | parent_company | company_name | revenue |
+----+------+-------------------+-----------------+---------+
| 10 | 1 | Pearson | Pearson | 5000.00 |
| 11 | 2 | Reed | RELXGroup | 4900.00 |
| 12 | 3 | WoodbridgeCompany | ThompsonReuters | 4700.00 |
| 13 | 4 | BertelsmannAG-NV | Bertelsmann | 4500.00 |
| 14 | 5 | WoltersKluwer | WoltersKluwer | 4100.00 |
+----+------+-------------------+-----------------+---------+
```
> ℹ️ For information about data source profiles, refer to:
> ℹ️
> ℹ️ - [Data source profiles](https://appfire.atlassian.net/wiki/spaces/SQL/pages/74323164/Configure+Data+Source+Profiles+-+9.x) for 9.x versions
> ℹ️ - [Data source profiles](https://appfire.atlassian.net/wiki/x/6xNuB) for 8.x versions
The sample query against the PUBLISHERS table looks like:
```sql
SELECT rank as "Worldwide Ranking", company_name as "Company", format(revenue,0) as "M Revenue" FROM publishers ORDER BY rank asc;
```
## Steps
The following steps demonstrates how to use Markup to insert the *SQL* macro on a Confluence page:
> Macro (table-plus)
>
> | | | |
> | --- | --- | --- |
> |  | ## Create Confluence page
Create a Confluence page to add the *SQL* macro needed to list out top publishers.
1. Create a page named *Top Publishers Worldwide* in a space accessible to the desired audience.
> 2. Click **Save** to save the new page. | |
> | --- |
> |  | ## Insert the SQL macro using the Insert Markup Menu
Edit the *Top Publishers Worldwide* page and:
1. Select **Markup** from the top menu.
> 2. Type the following into the editor window: (Note the data source name referenced)
> 3. Click **Insert** to insert your Markup within the page.
> 4. Click **Save **to save your page and view your results.
## Alternative:
> Macro (nested-table) | **How to insert Markup from the menu**
**Alternate method:**
 |
## Explore Tutorials
We've prepared a number of [tutorials](https://appfire.atlassian.net/wiki/spaces/SQL/pages/74322767/Tutorials) which demonstrate how to use our *SQL* macros with the native *Chart* macro.