Paql queryemplois

I am looking for a freelancer to create a social media post for me. This project involves creating an image post using a combination of both my own supplied images and also creating images. The post should not exceed 140 characters. This is a one-time project with an expected completion timeline of 1 - 3 business days....a combination of both my own supplied images and also creating images. The post should not exceed 140 characters. This is a one-time project with an expected completion timeline of 1 - 3 business days. I look forward to working with the ideal freelancer. i need somting like this for my restaurant : https://www.freepik.com/free-psd/food-menu-restaurant-social-media-banner-template_31598573.htm#query=post%20media%20social%20food%20chiken&position=24&from_vie...

...Solid understanding of writing test cases to ensure data quality, reliability, and high level of confidence. Track record of advancing new technologies to improve data quality and reliability. Continuously improve quality, efficiency, and scalability of data pipelines Knowledge of working with queries/applications, including performance tuning, utilizing indexes, and materialized views to improve query performance. Identify necessary business rules for extracting data along with functional or technical risks related to data sources (e.g., data latency, frequency, etc.) Develop initial queries for profiling data, validating analysis, testing assumptions, driving data quality assessment specifications, and define a path to deployment. Familiar with best practices for data ingesti...

From the given training data, our goal is to learn a function that can predict the wine quality rating of a wine sample, based on the objective features. the predictor function will be constructed as a k-d tree. Since the attributes (objective features) are continuously valued, you shall apply the k-d tree algorithm for continuous data, as...predict the wine quality rating of a wine sample, based on the objective features. the predictor function will be constructed as a k-d tree. Since the attributes (objective features) are continuously valued, you shall apply the k-d tree algorithm for continuous data, as outlined in Algorithms 1. Once the tree is constructed, you will search the tree to find the 1-nearest neighbour of a query point and label the query point more details ...

I need help creating an Excel Database to store my data and query it as needed. Additionally, I will need the database to be integrated with an existing system. Having expertise in VBA is a must, as it will make setting up the database much easier. I’m looking for someone who’s experienced with creating such databases, and who can integrate the data with my existing system. I need someone who can quickly deliver results, so being able to execute the project diligently and accurately is also essential. If you think you can help me with this, please reach out!

...receipt and a copy of the invoice comes to the company/ can be exported ad hoc. If you believe you can deliver this project to a high standard, please get in touch. The landing page contains backghround image, logo, logon/registration button, dialogue entry container with "ask" button, and text on initial landing that is overwritten with the answer text, and a link to a contact page to submit a query....

I am in need of someone to add basic custom coding functionality to my Wordpress site. I have specific functions in mind that need to be coded. The project does not require complex functionality, but instead requires basic coding...I have specific functions in mind that need to be coded. The project does not require complex functionality, but instead requires basic coding skills. If you are an experienced coder and believe you can complete this project in a timely manner, I'd love to see your proposal. Thank you for your interest! The specific requirement is to be able to conditionally display a page based on a databases query that takes the value of a hidden field on a contact 7 form and if a match is returned then display page otherwise display another page. The site is hos...

...populate a table with lots of content, you are required to estimate the number of records for tables that you created. The absolute numbers are not as important as the relative sizes of the tables. This information is important for choosing indexing and query optimization. 4. Fourth phase: you will come up with 10 typical queries that you expect to run frequently on your database. A good place to start is to look at the search and browse sections of the Facebook website. You will need to write down the English question and its SQL statement for each query and run them in your Oracle database account. TURN IN: • A final report (.doc, .pdf, .txt, or others) of about 8 pages that includes: o ER diagram for your design including assumptions that you made, and justificati...

I have a Java application that makes it easier for me to query for and apply for new jobs on Indeed but it needs some debugging. It is dependent on my local configuration and the only way to run it is with screen-sharing. I want to do this daily at 3 p.m. My current time is UTC +5 and is accurate at this URL I want to do this with you every day without fail where the goal will be to use the tool or do the work manually to apply to at least 25 jobs where my qualifications match and where the employer has been flagged as "responsive". Indeed does a good job of saving my most currently uploaded resume in the system as well as some prior responses. You can debug as much as you want but we must reach our target of 25 applications as well. Considerable experience in Java a...

I would like 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...consistent across years. You may want to scrape the spreadsheets programatically rather than downloading them by hand. (2) The number of students enrolled in each grade is available from the Elementary / Secondary Information System, at . This data source is relatively easy to work with and just involves checking the right boxes. Please limit your query to public schools. Merging (1) and (2) may involve turning rows into columns, stacking datasets, and renaming columns and variables.

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

...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 should be able to connect to SQL backend database. The service should be able to fetch data from database tables as per the specified query. The service should be able to update the status of sent emails in the SQL database. The service should be able to log errors and exceptions in a separate table in the database. 2.2. Non-Functional Requirements 2.2.1. Performance The service should have low memory and CPU usage. The service should be able to handle a high volume of email sending and database updates. 2.2.2. Security...

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, please let me kn...

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...

...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 function which will call them all and process them one by one , till it gets a value of true back(which means db data has changes so we need to recall db all over to ...

...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.

...company's IT staff to ensure that they were comfortable working with the new Postgres databases. Result: The migration from MySQL to Postgres was a success, and the company's databases were running more efficiently and with greater stability. Specifically, here are some of the results we achieved: Improved performance: Postgres proved to be more efficient and reliable than MySQL, resulting in faster query response times and reduced downtime. Improved scalability: Postgres provided better support for scaling up the company's databases as they grew, allowing them to handle more data and users with ease. Improved data integrity: The migration process ensured that all data was accurately and completely transferred to Postgres, and that all tables and indexes were prop...

I need an experienced Android mobile app developer to create an engaging consumer-facing mobile app for me. The app mu...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 Advertisement integration I'm looking for someone who can bring creative ideas to the table and build me an app that stands out...

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.

...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 develop SQL queries that are optimized and can effectively reduce the memory usag...

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

...to map each asset price to each end point. Eg. BTC —> - Each node can only connect to 1 api so front end needs to also request API key and auth credentials. - We'll configure each node's Gun JS settings as a signaler (for peer discovery) to make the network work like a distributed API. - IMPORTANT : We'll also create HTTP routes on each node to act as endpoints that query the graph and return the latest price for an asset. E.g BTC, ETH, USDAUD etc, meaning we may need to create an interface for Nginx so if endpoints are URL or IP based we can get price from IPADDRESS/price/asset or URL/price/asset - test premium API credentials will be provided. ...

I am looking for an experienced Python coder to write a 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 s...

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.

...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 language: i. To query all deposit events for this contract. You do not need to query all of them, but your code should faci...

...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 language: i. To query all deposit events for this contract. You do not need to query all of them, but your code should fa...

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.

...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 : Website should be responsive (it should work effectively on mobile phones and desktop as well), fast product search tab, recommender syst...

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.

Hello, I am looking for a concerned freelancer to help me with developing a web scrapper to scrape one specific web-site using multiple 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 solu...

...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 be queried. If you feel you possess...

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 includes RFQ#, Customer, RFQ date, Customer, Contact, Due Date, Quantity, Produc...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. for th...

Requerimos ayuda para completar un proyecto, el cual requiere construir 3 módulos para un proyecto, y la parte de registro, inicio de sesión, seguridad de usuarios y protección de rutas… El proyecto consta de las siguientes tecnologías: React NextJS React Query React Hook Form TailwindCSS Firebase Auth El diseño y el API ya están hechos, básicamente se requiere que le den funcionalidad al sitio en esos modulos. Los formularios son grandes, de alrededor de 40 campos divididos en 3-4 pantallas o en un modulas en algunos casos… Si se sabe Canvas sería un plus… Freelancers solo de Mexico y America…

...modeling and design: The candidate should be proficient in creating Entity-Relationship Diagrams (ERDs) and 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. Da...

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 that I can initiate process of Payment gateway integration. Visit...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.