SQL Queries in Python

My website is a big data analytics tool, scanning over 100 Million lines of data for every query. Now I want you to refine my search by adding further SQL commands. The search is written in Python and based on Elastic Search. The website is built on Symfony. THE JOB IN DETAIL: 1. add premade navigation bar and link content at page bottom, fixed, z-index above all website content link content of search bar 2. add pagination 10 search results per page. Enough pages to show all results. “<” and “>” jump two pages. 3. revise search process Country Selection If a country is selected, only show search results of shipments which list that country in the column “Country”. If USA is selected, show all search results. words from multiple columns When searching for multiple words, like for example: “the north face” + “tent”, show all search results that have all words in the columns “Consignee Name”, “Shipper Name” and “Product Desc”. Allow the words to be found in different columns. In the example above “the north face” could be found in “Consignee Name”, and “tent” in “Product Desc”. 4. revise website delete previous search field. Scale down the height of the top navigation’s background to just underlay the links.