Query project data jobs

...the percentage of students who were retained in grade, by US state, grade in school (K-8), in four different years (2011-12, 2013-14, 2015-16, and 2017-18). So this is a straightforward but laborious data acquisition and merging task. Take a look at the instructions and data sources below before you place a bid that's realistic about the time required. The percentage of students who were retained in grade can be calculated by dividing (1) by (2) below: (1) The total number of students retained in each grade and state is available in the State and National Estimations tab of the Civil Rights Data Collection, at . This is probably the hardest part because it involves downloading a different spreadsheet for each state and year, and the formatting of the spreads...

I need an HTML front end for Chat GPTX that will enable a user to cut and paste text into a box then hit one of six buttons below to have Chat GPTX rewrite the copy in a specific style. The button should both choose the style and initiate the call the Chat GPTX's API So the front end will send a query to Chat GPTX in the form Rewrite this {Copy from Box} in the style of {Style associated with button} Those styles are: Disruptors: Elon Musk Masters of the Universe: Jeremy Clarkson Heart and Souls: A Jerry Seinfeld monologue Campaigners: Simon Sinek Visionaries: A TED talk pitch without mentioning TED or talking Chief Fun Officers: Russell Brand Please see attached PDF for a very rough idea of the layout

Project Overview 1.1. Objective To design and develop a Windows service that automates sending emails and updating SQL backend database. 1.2. Scope This project document outlines the requirements, architecture, design, implementation, and testing strategy for the Windows service. Requirements 2.1. Functional Requirements 2.1.1. Email Sending The service must be able to send emails using SMTP protocol. The service should be able to fetch email recipients, subject, and content from the SQL database. The service should be able to handle email attachments. The service should provide support for multiple email providers (e.g. Gmail, Outlook,yahoo, smartermail etc.). The service should support retry mechanism for failed email sending. 2.1.2. SQL Backend Update The service shou...

My project involves creating a Wordpress Search PlugIn that will search Content as well as post and pages. The PlugIn will be coded in Full-text search, with a level of customization of Basic. The PlugIn should allow users to easily search through blog content as well as pages and posts according to their desired query. Specifically, the PlugIn should offer basic features including easy navigation and search, filtering results according to post categories, and an autosuggestion search box. I am looking for someone who can develop this PlugIn quickly and efficiently. The ideal candidate should have solid experience in developing PlugIns in Wordpress, particularly in regards to creating full-text search and basic customizations. If this unique project interests you, pl...

columns - Jan2034, Apr2034, Jul2034, Oct2034, Jan2035, Apr2035, Jul2035, Oct2035, Jan2036, Apr2036, Jul2036, Oct2036 table path - -- write simple sql query ---- targetallocation(column) is the first non zero value and the corresponding month/yyyy is the 1stmonthyyyy as starteff(column) and the same ending value giving row is endeff(column) and if the value changes then (target allocation(column) is the first non zero value and the corresponding month/yyyy is the 1stmonthyyyy as starteff(column) and the endeff is the day if it ends in Janyyyy then 31marchyyyy , Aprilyyyy then 30 june yyyy , Julyyyy then 30septemberyyy, octyyyy then 31decyyy)

I am looking for an experienced freelancer to help me with a dynamic 365 FinOps - SQL query project. Specifically, I need a data retrieval SQL query link to excel file. The query must be able to access invoice data. I have fairly complex needs and require someone with a great deal of experience in writing efficient and secure queries. I need someone who understands data structures, relational databases and how to best design them. Familiarity/experience with Dynamics 365 is a must. If you think you are capable of completing this project and meeting all my requirements, please do not hesitate to contact me. I look forward to working with you.

I need help with Crystal Reports 8.5 and Visual Basic 6. Specifically, I am looking for troubleshooting errors remotely or online. I need this help as soon as possible. A financial application was don...need this help as soon as possible. A financial application was done using Visual Basic 6 with Crystal Reports. It has 47 reports done in Crystal Reports 8.5 that reference ttx files. I am upgrading the application to C# but the reports are an issue. Because the reports reference txt files all the fields are defined there and I cannot determine what tables they reference and exactly what SQL query is used. The database is an Access database. I need someone to examine the application code and extract the queries and create views for all the reports which I can then use in my C# ap...

Edit Code like this: Website: After Login: "Call to undefined function mysql_query()" The website runs on Joomla.

I have the database below set up in SQL. I would like a query that calculates the liquidation fee when a user decides to liquidate some of their total investment. If the amount the user wants to liquidate requires liquidating more than one of their investments, the oldest ones should be sold first and the fee is 8% of the investment minus 1% for each full year old the investment is with a minimum fee of 0%. For example, an investment made 9 years ago would have a 0% liquidation fee and an investment made just over three years ago would have a liquidation fee of 5%. I want to know the total liquidation fee for the amount that the user wishes to sell. In this case, the user with a userid of 1234567 wants to liquidate $238 of their investment in the property called Links. After liquida...

I'm in need of an experienced PHP expert to handle an ongoing process for my project. I require someone experienced in development for off-site work, and who understands the ins and outs of databases and related frameworks. In particular, I need someone well-versed in PHP 7. Some level of flexibility would also be appreciated. If you are an experienced and reliable PHP developer, please consider applying for this project. task description : we have an online game , that stores players tasks in id , with every page refresh we execute a query thats job is get the tasks with execution time = now . after that , we will create some kind o locker on db in order to forbid processing same task twice ,if locker created successfully , then we must go to processes functi...

...get_page_by_title() (previously declared in /home/flyprinc1/public_html/wp-includes/) in /home/flyprinc1/public_html/wp-includes/ on line 4557 Notice: Function is_embed was called incorrectly. Conditional query tags do not work before the query is run. Before then, they always return false. Please see Debugging in WordPress for more information. (This message was added in version 3.1.0.) in /home/flyprinc1/public_html/wp-includes/ on line 5865 Notice: Function is_search was called incorrectly. Conditional query tags do not work before the query is run. Before then, they always return false. Please see Debugging in WordPress for more information. (This message was added in version 3.1.0.) in /home/flyprinc1/public_html/wp-includes/ on line 5865 There

Edit Code like this: Website: After Login: "Call to undefined function mysql_query()" The website runs on Joomla.

...databases to Postgres. Here are the steps we took: Analyzed the existing MySQL databases to identify any issues or constraints that might affect the migration process. Created a detailed migration plan that included steps for transferring data, recreating tables and indexes, and testing the new Postgres databases. Worked closely with developers to ensure that any application-level changes required for the migration were made in a timely manner. Used specialized migration tools and scripts to transfer data from MySQL to Postgres, and then manually verified that the data was transferred accurately and completely. Recreated tables and indexes in Postgres, and then tested the new databases to ensure that they were functioning correctly. Provided training and support to...

...mobile app developer to create an engaging consumer-facing mobile app for me. The app must be built for Android devices, but I'm also interested in hearing about options for scaling the project to include iOS support. Furthermore, I want UI/UX design services, as my project calls for a unique and user-friendly design. Basic Specifications as below: 1 Multi Language (Initially 3 (English, Gujarati, Hindi) 2 Map Integration 3 Route dislay on map 4 Camera Integration 5 Share feature 6 Dynamic Data feeding/Update/Notification from Server 7 Integration with Server 8 Form Filling 9 Message integration 10 Data query and response with server to update dynamic input and display information 11 Total Main 14-16 Screen 12 Approx. 4-6 sub screen 13 Advertise...

I am offering an opportunity to work on a fascinating conservation biology project. Develop a list of search terms that can be used to generate a query in Web of Science that will capture as many publications as possible relevant to the concepts included in your conservation question. Create a table that includes the main concepts of your question and the associated query generated from the list of search terms. Using the PRISMA guidelines create a diagram that transparently demonstrates how studies were assigned (as above) and were removed or included in the meta-analysis. At minimum, please demonstrate how you handled 200 papers.

...must. This person needs to be highly experienced, knowledgeable and reliable when it comes to database development. The successful candidate must also need to have strong technical expertise and problem-solving skills. The developer should have knowledge of database management system concepts, implementation and usage as well as data flow and storage techniques. The successful candidate will be able to identify and resolve issues related to database functions, query optimization, indexing and dealing with database constraints. The developer should have at least 5 years of experience in developing software applications and have in-depth knowledge of current technologies and their uses in the development of enterprise scale databases. The candidate should be able to develo...

Query 1: Produce a report on Adult's shoes performance for the date range 26th-30th. (Revenue, Transactions, Clicks, Cost Impressions, Cost/Click) Query 2: Identify the top 5 products by revenue for each gender. (male, female, unisex) Using WITH, SELECT, INSERT, INNER JOIN, ORDER BY, AS, ASC PD: There is not access to database, only from Excel sheet. Solution in Excel is already done

Hi Guys.. I’m a dev and need to outsource a part of a larger project. Currently, we get prices from an API, but we want to create a distributed price aggregation network which will allow for a distributed set of nodes to connect to different APIs and keep a distributed median price db using Gun JS (), a distributed graph database. - We want to Monitor 35 pairs. Full list will be provided. -To monitor the APIs and insert records into the Gun JS database, we'll create a a node service that utilise Gun JS. This node js service will fetch data from APIs and insert records into the Gun JS database at the 0.5-second interval. - To ensure the correct price is selected in cases of discrepancies, we'll use a median consensus mechanism by modifying the core funct...

...script which will query an Arbitrum chain wallet balance. The script should be written in Python, and capable of running on Mac OS. The script will take parameters such as private key, and return the cryptocurrency wallet balance associated with that account. The returned data should be reliable, accurate and up-to-date. the format of the result should: Private key :: Balance in ETH: Balance in USD :: Wallet address The script should also be well coded with best framework and easy to customize and modify, should the need arise. Attached you can find a sample script which shows almost everything that needs to be done, your task is to write a better and working script. ( sample private keys are included in comments on same script) If you think you are qualified for thi...

The job involves analyzing and providing feedback on text, web pages, images, and other types of information for leading search engines, using an online tool. Raters log on to the online tool to select tasks to do on a self-directed schedule. A Rater reviews the results returned in a specific search query and rates them in terms of relevance The platform is open 24/7, we need a full-time worker. Please review the guidelines attached and let us know if you have worked with them.

Collect data and evaluate the performance using code on Multi-Join Query Optimization Using Ant Colony Algorithm and Genetic Algorithm. At least 6 Tables in the data. I have added a Paper. You have to follow ACO and GA as given in it. No need to Perform a Combination of Both.

... Solana Data Script a. To Create a free Quicknode API Key a. Using the Solana docs, write the following scripts in your preferred language: i. Query the latest block ii. Get a list of all Validators (or subset, but logic in code to get all) iii. A list of delegators for the largest validator (or subset, but logic in code to get all) 2. PancakeSwap Data Script a. Get access to an Ethereum Archive Node b. Context: will be given c. For the Stake Cake Pool, which currently has > 250,000,000 CAKE staked to it, find the following information: i. When was the current staking contract deployed onto mainnet? Please link to the transaction in which it was deployed. ii. Where can we find the ABI and the Source Code for this contract? d. Write a script in your preferred lan...

...Solana Data Script a. To Create a free Quicknode API Key a. Using the Solana docs, write the following scripts in your preferred language: i. Query the latest block ii. Get a list of all Validators (or subset, but logic in code to get all) iii. A list of delegators for the largest validator (or subset, but logic in code to get all) 2. PancakeSwap Data Script a. Get access to an Ethereum Archive Node b. Context: will be given c. For the Stake Cake Pool, which currently has > 250,000,000 CAKE staked to it, find the following information: i. When was the current staking contract deployed onto mainnet? Please link to the transaction in which it was deployed. ii. Where can we find the ABI and the Source Code for this contract? d. Write a script in your preferred l...

I need codes for phpmyadmin to query my databse. Mostly for woocommerce reports. current stock value inventory count inventory value fast moving slow moving comparison forecasting tip profit expiration and email notification closing inventory, items sold, items sold per day, days cover, and average cost. top sellers, worst sellers, and year-over-year growth deadstock cost of goods taxes, discount etc thanks

Count the number of times in a row a taxonomy is used in a loop until it's not and store then number, then continue checking the next number of times its used until it's not until the wp query goes through all posts. Full details/example in the attached pdf.

...website design and development to help me create an online shop. My shop will offer customers an extensive selection of physical books. I plan to provide customers with the option to purchase items online and will definitely be offering delivery services. The scope of this project includes creating a website that is both user-friendly and visually attractive. The website should have the ability to easily add and manage new products, while providing a secure payment gateway, Books category display, whatsapp icon for any query, about us page, Cart, login and signup page, order confirmation mail generation. Ultimately, I want my customers to have the feel of an actual bookstore experience from the comfort of their own homes. I also need following things in my website :...

hi guys I have a database currently in emergency mode. The DBCC CHECKDB query suggested repair_rebuild I have put the db in single user mode but the repair option wont run because it says its in emergency mode. Need an excellent SQL tech to assist. thank you

hi i need codes for phpmyadmin to query my databse. Mostly for woocommerce reports current stock value inventory count inventory value fast moving slow moving comparison forecasting tip profit expiration and email notification closing inventory, items sold, items sold per day, days cover, and average cost. top sellers, worst sellers, and year-over-year growth deadstock cost of goods taxes, discount etc thanks

Looking for a Database expert who has extensive experience in Amazon Marketing Cloud and SQL query. Would like to generate some data from the existing tables and optimize the complicated queries.

...queries. The project requires scraping only some specific pages, which need to be done accurately and efficiently. Moreover, I also require additional processing of the scraped data. Most important things for me are: a) ability to query web-site by providing information in three different fields in order to be forwarded to next / output page b) the speed of scraping, supporting multiple threads using socks proxies (for example 100 scraping sessions at once) + updating proxies and rotating them every certain period of time c) convenient method of saving the output data (excel database, text files) - which in future I could integrate with some solution to make search available for some specific details. d) stop retrieving any more results, in case you have re...

...build the following features: 1. Role-based admin logins 2. Bulk upload of influencers through sheets 3. Select/reject profiles features 4. Influencer listing page based on the filters user set like location, follower range, avg video views etc. 5. A details page of the influencer 6. export the list of influencers from the listing page 7. Create/edit campaign form (broken down into 2-3 steps) 8. Query to suggest influencer profiles based on quantitative criteria set in the created campaign 9. Lists - a feature where we can create a list with a specific name and put multiple influencer profiles there 10. Send automated WhatsApp messages to all the shortlisted influencers 11. Capture their responses via WhatsApp 12. Export this list into a sheet 13. A separate form for the influen...

I'm looking for a Google Sheet Query specialist to help me build a project that can automatically track time and generate invoices. The ideal candidate should be well-versed in commonly used Google Sheet functions such as the =QUERY() function and be able to work with external sources of data, if and when necessary. The main purpose of this automation project is to automate the invoice generation process and streamline the tracking of time. The ideal candidate must have a deep understanding of the =QUERY() function and the ability to use =Importrange() and =VLOOKUP() functions, as well. The project may require the use of external sources of data, either in the form of an imported file, or as an online database which needs to ...

I am looking for a talented and experienced Laravel developer to help me fix the search result and sort function on my website. It is currently running on Laravel 5, but the particular version is unknown. No database query changes are necessary, although it could be helpful. The task does not have a specific time limit, though I do expect the project to be completed in a timely manner. If you have the skills and expertise required, I invite you to bid on this project.

Hi, I need someone to write an ansible playbooks to: Cloudflare: -------------------- Create the zone Add cname record import a zonefile Change SSL mode Create a loadbalancer Runcloud: -------------------- create the app create the db create the dbuser create the db grant ... Other -------------------- upload files using via SFTP execute a mysql query .. I will provide an ansible server and accounts where dev can be done.

I have a filter function where I'm selecting data based on the date in the a dateTimePicker tool. I just need an if checkbox is checked then apply filter adding to it. It is in query syntax and not method syntax so that might be the issue. Should be really simple for someone experienced.

Looking for android and iOS developer for a small sales project. Feature list : Login/Sign Up Listing of queries Admin Can set the status of Accept /Reject for any query Push Notification Edit Profile Logout

my wish is to have a database to track my RFQs (request for quotes), Qts, Sales Orders with vendor orders (Purchase Orders to fill the customer order), invoices, and commissions for my independent sales reps. 1. RFQ include...commission to pay Reps, Sales Reps, Date checks received, Sales price is established from Cost ....apply formula based on cost X Risk factor, X Warranty factor, X Margin factor Will figure this out after the first part is in place. i have a spreadsheet that i'm using now and i'll share it when i find the right person to do this project. please advise time expected to get the first tables done, so i can begin populating them. The reports will be payroll which will run a query based on time range, with income received and commission calculated....

...designing normalized database schemas to minimize data redundancy and ensure data integrity. Normalization techniques: The freelancer should be familiar with various normalization forms (1NF, 2NF, 3NF, BCNF, 4NF, 5NF) and be able to apply them to optimize database structures. SQL (Structured Query Language): Proficiency in SQL is crucial for working with relational databases, as it allows the freelancer to create, manipulate, and retrieve data from the database. Familiarity with database management systems (DBMS): The candidate should be experienced in working with popular relational database management systems like MySQL, PostgreSQL, Oracle, or Microsoft SQL Server. Data analysis and problem-solving: The freelancer should be able to analyze dat...

I have a ready software where users can upload a data using input field to the database. But I need a system where user will be able to upload bulk amount of data only with PDF or DOCX files. And also a Boolean search(Jira Search Query) You must have the below experiences. *OCR Expert for PDF *Boolean Search (Jira Query Search Filter) Please submit your proposal after reading the description.

The freelancer should have a track record of successfully getting articles approved on Bing Pubhub and Google News. They should be able to demonstrate their expertise and understanding of the guidelines and requirements of these platforms. Also for Google News I need my blogs feature in News section when you search query through Google Search (Refer Screenshot for more info)

visit I am short of time and will require help of professional to complete it. Have loaded woocommerce plugin. 5 sample digital proudcts added to shop page of so t...facilitate multiple digital products in table format with 5 or 6 types of filters above and in left side bar. I have tried both plugins demo and they are suiting my needs. Will need professional help for designing and usage of appropriate blocks for shop & products pages. Wanted to install membership plugin for subscription feature for viewing excel data in table format. (wpdata table plugin purchased for my site). Need to convert 80k row tables to my sql query so that I can import through wpdatatables. I think, this work should get finished in 3 or 4 days. If interested, then let me know.

I need someone to modify my macro to also have 2 more cases for shift start and shift end times separately. right now it includes the full shift time IE: 3:00 PM to 4:59 PM. I need just the start time in column O and end time in column P. The file is on a VM for the database connection so if you want you can also work on team viewer or I can send you the code and then you can send it back to me.

I already have a NAVBAR. I need a searchbox to fit in it (align) on the rightside both for regular and for media queries. The search box should show input box with magnifying glass at the end to send the query back to the Python server. I need autocomplete suggestions defined in Javascript.

I am looking for someone to write a query for me. The query needs to be in the Select language and be written for a MySQL database. I am looking for a query that will return the entire contents of the database. I need someone with the expertise to write a high-performing query, so I can have up-to-date information at all times. If you think you are the right candidate for this project, please get in touch.

...clarifications can be provided as necessary. This project involves creating and implementing the architecture, overall layout, coding, and testing of the web application. The full scope of the project should include the complete development for all aspects of the web application. I am expecting a scalable and reliable system, built with robust and secure coding standards. Any suggestions that could create additional value to the application are welcome. We aim for the most simple implementation possible at first. The full app will be around 7-10 pages. Requirements (Use Cases): - User shall be able to create an account / login - User shall be able to receive, interact and download content in an "user area" - User shall be able to enter information in a qu...

The project is to create a web-based online learning system. It needs to be hosted on a local computer and not on any hosting site. 3 different files for Html CSS STYLESHEET and JS. Description: It will be a web-based online learning system with a name, a banner/heading, and navigation menus/links/buttons. You can choose a nae for your application and a logo. The application will have three pages of tutorials, accessible through navigation menus or buttons, to teach the HTML, CSS, and JavaScript courses. Each course should have at least five topics. Topics should include text, images, tables, and lists. There should be a quiz for each course. Each quiz should have at least five Multiple Choice and True/False questions. There should be a button to submit the quiz. After the quiz is...

I'm looking for a Freelancer to help me set up Microsoft Power Automation for my business. The primary purpose of doing so is to automate manual processes, saving me time and effort. However, I do have some specific requests related to the setup and I will need you to guide me in my system. Currently, ...purpose of doing so is to automate manual processes, saving me time and effort. However, I do have some specific requests related to the setup and I will need you to guide me in my system. Currently, the process takes time and I'd like to reduce this time in order to improve my efficiency. If you are an experienced professional with knowledge of Microsoft Power Automation flow, desktop and power query and can help me with my setup, please contact me. Your English needs to ...

The Requirement is , need to run queries using data-lake using nodejs currently we are running queries over mongodb but the query time is too high so need to use data lake over mongodb for imporving the quering speeds in nodejs

...new version of the Web site 5. We have a link (plugin configured correctly) between the Facebook/Instagram accounts that works fine and needs to be preserved 6. We have google AdWords configured correctly and needs to be kept as is. This item needs to be offered as a separate item! 7. We need a plugin that could search all sales based on the timeframe: month, week, or day and based on the query it needs to create a downloadable CSV file. All rights for that plugin should be in our name, and we should be able to distribute it as a paid or free plugin depending on our decision. The developer in this case will transfer all the rights to us, and will not have any request further. If we are intending to hire the same developer or somebody else to maintain the plugin that must b...

I am looking for a freelancer to help me figure out how to use Excel Power Query in accessing REST API. I will share my screen and you will show step by step how to to do that. Kindly type AP on the top of your bid.