1  # Datapack SQL query examples
 2  
 3  Since datapack uses SQLite database to store all required server data/assets about world,
 4  it is possible to use SQL to query for particular information that may be hard to track
 5  using conventional text files. For example, SQL can use information from multiple tables
 6  and extract various data pieces from JSON, that would normally take multiple steps when
 7  writing a dedicated script.
 8  
 9  Format is SQL query with explanation and possible examples of returned data (a snippet).
10  
11  ## Examples section
12  
13  ### Raid boss npcs with no minions
14  - `select * from npc_data where type = 'L2RaidBoss' and not parameters_json like '%minion%' and title = 'Raid Boss' order by level`
15  
16  ## Raid boss npcs only with minions
17  - `select * from npc_data where type = 'L2RaidBoss' and parameters_json like '%minion%' and title = 'Raid Boss' order by level`