I need an Excel VBA Tool that can extract airfare and other flight information from Google Flights. The tool should run using an interface (mask) that lets me choose the following: - Departure Airport (code) - Destination Airports (codes separated by a comma) - Departure Date - Return Date - Class of flight (multiple selection must be available for
I have MongoDB collection. I have to group the documents in that collection based on the monthly cycle. For example, the cycle date is 20 of each month. I have to group the documents like 20/06/2018 to 19/07/2018 , 20/07/2018 to 19/08/2018.
I need someone to write a simple sql query to copy fields between tables
Hi, we want you to build a php website, based on an EXCEL sheet. we will provide the excel sheet, which has approximately 26 columns, (including auto calculated formulas based on dates) The main function is for this database to be accessed in a user friendly format (both in form view per record, or in table view showing all records) There will also
we have a form for insert data, we need on submit to create a query before to process to check if data exist and IF exist show a modal with alert and name of data else process
I need someone freelancer to help me to fix the query below: select count(distinct p.products_id) as total from (products p) left join manufacturers m on (m.manufacturers_id=p.manufacturers_id) left join specials s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on
...open the excel document attached, you'll notice there are 5 columns: queries, clicks, impressions, CTR (click through rate) and position for a fictional bike company called "example". This is example data downloaded from Google Search Console about a fictional bike company called "Example". Google Search Console allows us to download data about ou...
...information. The code being read will be a primary key that will be used to query an already prepared viewer in the MYSQL database. The resulting data from this viewer will be presented to the user as shown below: The user can only consult the data, no change is allowed. All data manipulations will be performed at the rear and will not be the responsibility
Query on Office 365 Excel Online to export the data. No bootstrapping. Need to use Dojo or jQuery, or find a way to get it into that format for me to use.
Project Duration: 1 Hour Project Overview When trying to run this query: SET `description` = REPLACE(`description`, 'â€™', ''') WHERE `description` like 'â€™%' We get the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right synt...
I am currently getting a 500 error on my website. I traced it back to an SQL query (SELECT XYZ FROM zip_code INNER JOIN city ON zip_code.city_id = city.city_id INNER JOIN region ON city.region_id = region.region_id INNER JOIN country ON region.country_id = country.country_id). The INNER JOIN country ON region.country_id = country.country_id part of
Scrape from a google spreadsheet into a database on Azure or EC2, and create a UI for non-technical people to query. Make sure certain users can add but cannot delete data from the db. Also the UI should sanitize and validate the data before entering it int the database.