Paql queryงาน

Hi there I have a pivot table that pulls information from a database. it displays day and month as values for each row. Now I want to be able to pull up year as well. This is the query right now SELECT`nombre`,`apellido`,`apellido2` ,`dia`,`mes` FROM `visitas` I would like to add: SELECT`nombre`,`apellido`,`apellido2` ,`dia`,`mes` , `ano` FROM `visitas`

I am looking for a skilled developer who can work with Microsoft SQL Server to create a query that select multiple columns from multiple tables.

I am looking for a freelancer who can help me create a MySQL query for data retrieval. The ideal candidate should have experience and skills in MySQL and query creation. The project involves the following: -to Remove such Characters from ID For an example ID = IG.1234567-1, ID = IG.1234567-1-BC in this example there is a -BC at last so dont consider -BC ID and -1-BC iD bcoz -BC is billing canceled like that - And Also Helps in SQL join As well Query If you have experience in MySQL and query creation, please apply for this project.

I am looking for a freelancer to help me with creating a PowerBi dashboard. The dashboard will draw data from an MS Graph Query and display the information in a visual format. I want the dashboard to utilize visualisations such as bar graphs, pie charts, maps, and table formats. I expect the dashboard to be able to draw from multiple data sources such as Excel files, external databases, or API connections. I have an existing query that pulls all the groups from Azure and displays them in the slicer(As show in the attached pic). All I need is to show all the members in a table from the selected group. Since I am asking for an experienced professional, the ideal candidate must understand PowerBi capabilities, technical limitations, and any other topics related to the proje...

mongodb rabbit mq query project

I need to update my logo, but I want to keep the existing colors and only change the name. The preferred file format for the revised logo is PNG. I don't need any additional design elements added. https://nl.freepik.com/premium-vector/mensen-familie-medische-zorg-logo-sjabloon_35215720.htm#query=wellness%20logo&position=16&from_view=keyword&track=ais Name must be Dushi Wellness Ideal skills and experience: - Graphic design experience - Proficiency in logo design and editing tools - Attention to detail - Ability to follow specific design requirements

I am looking for someone to conduct a Performance Test on how my Airbnb listing ranks in one country, using a desktop computer. The goal of this test is to determine how well the listing performs in terms of visibility and engagement. This test is intended to measure the components of the Airbnb algorithm such as relevance to the search query, availability, rate, and other user experience factors. The results of the test will be used to guide decisions on how to optimize my Airbnb listing results. This is a very simple project i am just looking for the top 20 airbnbs if one is searching as 1 ,2,3,4,5,6,7 people I am only interested in full apts or houses I am trying to understand if there is a diference depending of which country you are coming from.

For my project, I am looking for an experienced freelancer to help me create a simple and efficient database with query functionality. I need a database hosted in Excel or other software that allows for easy form entry. Query functionality is important to me, but I'm not sure what type of query I need - so advice in this area would be really appreciated. My criteria would be the Data Type, Number of Entries, and Date Range. This project is time sensitive, so having somebody experienced with databases and queries who can work efficiently and quickly is ideal. I need to create a database of vendors and subcontractors with the ability to search by different criteria with easy entry.

Generating text file for all the orders and invoices. when a product has warrant selected, the product listed 2 times. one with warranty and another one without warranty. 1. fix the duplicate lines of product when warranty selected 2. we want to take this file and have a separate controller, it should be called whenever we want for debugging purpose when we pass a increment id, in the query string, it should generate order and invoice file for that increment id alone

I am looking for a web development specialist to build a static website for me which will have the data from two existing database tables connected to it. Additionally, the website is intended to be hoste...skills of a web developer to configure the IIS server, design and program the website, and create the proper protection for the data. The website should be visually appealing and easy to use, while being built and maintained using web standards to ensure compatibility between devices. I have a current windows 10 computer running IIS, and have attached it to my sql server and i also have the sql query written out. exactly what i need is a basic blank webpage, with a place to enter an item #, and click submit, then it will fill out data into 2 fields for quanity on hand from my sq...

Hello I have managed to query Facebook Graph API and extract correct data, which is available at an ad_id level. Now my problem is that we have hundreds of ad_ids, due to which the API keeps reaching its rate limit. So I want someone who ALREADY HAS PAST EXPERIENCE of working with Facebook Batch Async API to send batch requests and get 100% correct data that I am after. Please do not bid if you DO NOT have past experience with sending batch requests to Facebook API.

Load the dataset into MongoDB. Then query the dataset using MongoQuery. Implement a Mongo/Flask API server for a dash frontend to visualise. dataset: 's%20Datasets/retails_data. P.s: you can suggest any dataset you would like.

After rebuilding my PC and installing a newer version of XAMPP (origin PHP version: 7.2.34 / new PHP version 8.2.4) several of my PHP programs no longer work. The attached files are for one of them. We need someone...received when running this program: Fatal error: Uncaught TypeError: mysqli_query(): Argument #1 ($mysql) must be of type mysqli, null given in C:xampphtdocsskokielabelspi_classes Stack trace: #0 C:xampphtdocsskokielabelspi_classes(20): mysqli_query(NULL, 'set global char...') #1 C:xampphtdocsskokielabelspi_classes(20): AbstractDB1->query('SELECT * FROM `...') #2 C:xampphtdocsskokielabels(194): user->item_list() #3 {main} thrown in C:xampphtdocsskokielabelspi_classes on line 20

Update existing web access to include a query for CAS # related data from seven tables.

I have a partially developed ms access project. I need to develop the function for sending emails of records contained in a form and automatically sending emails for expired records form a query

I am looking for someone to help with developing a custom Azure Devops Extension. Must be familiar with the Azure Devops SDK, Azure Devops Api, React / Typescript, REST API. This project will have several phases. The first phase is: 1) Creating a Hub Group 2) Adding a Hub 3) Adding the Query UI from SDk to that user can run queries.

Hello I have managed to query Facebook Graph API and extract correct data, which is available at an adid level. Now my problem is that we have hundreds of ad_ids, due to which the API keeps reaching its rate limit. So I want someone who ALREADY HAS PAST EXPERIENCE of working with Facebook Batch Async API to send batch requests and get me 100% correct data that I am after. Please do not bid if you DO NOT have past experience with sending batch requests to Facebook API.

...for location selection Home screen: Shows the user the current beach conditions and whether it's a good day for going to the beach, along with a user-friendly scale ranging from "Excellent" to "Poor." Also displays the sunrise and sunset times for the current day. Includes a search bar for finding specific beaches. Beach search results: Displays a list of beaches that match the user's search query. Each beach listing includes a photo, name, rating, and distance from the user's current location. Beach details: Shows detailed information about a specific beach, including parking availability, beach amenities, and water quality. Includes a map view and directions to the beach. 7-day forecast: Displays a week-long forecast with recommendations o...

...furniture and outdoor furniture and furnishings in the United States. The ideal candidate will have experience in researching and compiling lists of suppliers, and will have excellent attention to detail. The project will involve the following tasks: - Conducting research on home furniture drop shippers in the United States on Big Commerce vendors here: - Compiling a comprehensive list of drop shippers with their contact information and product offerings and pricing - Providing recommendations for the best drop shippers based on their reputation, pricing, unique offerings and customer service - Delivering the final list in a clean and organized format, such as a spreadsheet or database The project requires the following skills

I have a project which I have to present to a large audience and all I have at the moment is loads of unstructured data. The data given is about a feasibility study to find out if it's worthwhile getting funding for an app that would help people cook at home and save money. All this is fictional but needs to be presented properly. I would need details of the work as I have to present this project

PoC: We need sample code (T-SQL) to query data from ssms from Salesforce sandbox rest api (json). - install ssms - get salesforce account - run t-sql and query salesforce api

...knowledge in business analysis and can compare different sets of data to uncover trends, dependencies, and correlations. This is a critical role, as the insights and knowledge gleaned from the analysis will inform strategic decisions. The analyst should have a strong background handling large datasets. The ability to visualize results, create meaningful and actionable reports, and work with SQL to query and process data would be advantageous. Moreover, the analyst must also have a strong understanding of Business Intelligence techniques and highly developed skills in presenting analytical data. The ability to incorporate data and information into succinct reports, presentations and documents to convey complex topics in an easy-to-understand manner is essential. If you think y...

...platform. To demonstrate my capabilities, I have been tasked with creating examples in a demo environment. While I can follow instructions, I am seeking a qualified individual who can provide me with 5 hours of personalized, one-on-one assistance through a screen-sharing application like Zoom. The assistance I require will cover various topics, including making HTTP requests, inputting and adding query parameters, transforming collected data, defining output, global variable definitions, running data flow from a UI, displaying data, firing actions with a button, previewing and publishing the application. To recap, I am in need of a qualified professional who is available to provide 5 hours of one-on-one help immediately, on US time zones, with excellent English language skills,...

I am seeking an experienced MySQL Admin/Performance Tuner to assist with an existing web application. The project involves reviewing DB setup and settings, looking at DB tuning and possibly proving assistance with query tuning. We are looking for someone who has extensive experience in tuning SQL databases, specifically MySQL databases in an AWS environment. The successful candidate should also have experience monitoring performance, and making adjustments to ensure optimal performance. The successful candidate should have excellent organizational skills, attention to detail, and be able to execute the project effectively and efficiently. We are looking for someone who can take charge of this project from start to finish, as well as someone who can advise best practices for data...

I am in need of a MySql expert who can help me optimize a query to reduce server load. The database structure is fixed and cannot be modified. This optimization needs to be done immediately. Ideal skills and experience for this job include: - Strong understanding of MySql database optimization - Experience with query optimization techniques - Knowledge of server load management - Ability to work quickly and efficiently under tight deadlines

We have a team of C# .NET developers but we are currently seeking a C++ developer to make some minor changes to an open source Windows C++ desktop application project. The program does not have an API interface, we would ...of C# .NET developers but we are currently seeking a C++ developer to make some minor changes to an open source Windows C++ desktop application project. The program does not have an API interface, we would like to add this. There C++ libraries available that offer this functionality. Then we will want the program to connect our web API and based on certain events we want the C++ application to query our web API and then display the results in the C++ interface. You should be familiar with Windows C++ applications and programming as well as an understanding of...

We have website, that consumes high CPU power and the hosting provider suggest me to optimize the queries. The website developer is not able to do these things. So i need a person who have wide knowledge in query optimization.

The procject, to be made on Microsoft Power Automate (Cloud) consist in creating a process with the following steps: > Once an email arrive (officex360) with Subject " TO BE SPECIFIED " > Create a copy of the attached file ( it is a .xls file ) > Apply a filter that exclude the all rows containing "VALUE I DONT WANT" in column "COLUMN TO CHECK" > Save the copy on a dropbox path Connections with email and drobox are already set, it should be a very basic task for who knows Mycrosoft power automate.

...allows my users to send a limited number of queries via an API call to GPT-3.5 based on a monthly package they select. For example, package #1 is $5 and allows for 10 API queries to GPT. Each API query will be based on 5 fields within their portal where the user enters information. When the user clicks a submit button located below these 5 fields, the API query is sent to GPT. Then information from those 5 fields is combined and sent to GPT along with a permanent prefix prompt that I have specified. (I use a similar Function in Zoho already and can provide access to that code.) Each API query will contain two questions for GPT. The GPT answers are then provided in two answer area/fields. Both answer areas will contain a heading, such as “Answer One&rd...

...file. I need someone who has experience with Python coding, web scraping, and creating databases. The ability to work quickly and efficiently is a must. All code should be written in compliance with any legal protocols for using online data. If you are confident you have the necessary skills and experience, please contact me for further discussion. I also want python code. Google job search query link is below & screen shot is attached. :1681386173284&source=hp&ei=veo3ZJWOD4GxoASWu7GwBA&iflsig=AOEireoAAAAAZDf4zWReEune2IBJx2S__TgbTvlV_F6K&uact=5&oq=devops+jobs+in+india&gs_lcp=Cgdnd3Mtd2l6EAMyBQgAEIAEMgUIABCABDIGCAAQFhAeMgYIABAWEB4yBggAEBYQHjIGCAAQFhAeMgYIABAWEB4yBggAEBYQHjIGCAAQFhAeMgYIABAWEB46B

Friends, I have to make a single-page download website and I also want to know whether this website is possible in WordPress or will be made in PHP. I have my own hosting and Domain name. I want a fully responsive website for any desktop and any mobile. and I want this website in 5 to 7 days also I,m providing all details and information. any query then contacts me. here is an example of some websites: :// :// ://

I'm looking to clean up an excel /csv file and create multiple columns from a single column. i'm attaching explanation. I need this either in power query, pandas or regex python. for speed purposes. will pay $30 thank you,

Requiero una persona que me de un entrenamiento sencillo y practico de dos horas sobre Power Query, alistando datos para conectar y subir los datos a Power BI. La idea es organizar aprender a organizar los datos bien para que al subirlos a Power BI, todo esté okey

I am looking for a freelancer to help me add pagination to the homepage of my WordPress Colibri WP child theme. Specifically, I need pagination for the homepage only and I require that it includes tags but not custom post types. Additionally, it must work with a specific search query. If you think that you can help me with this project please let me know. Thank you!

Hello, I have a Snowflake database, which has 3 columns, Column 1 is a unique identifier and Column 2 and 3 are start and end date for leave. I want a new column based on following condition: IF ACTUAL_LEAVE_START_DATE is not null Count the number of days between 2023-05-11 - 2023-06-01 for ACTUAL_LEAVE_START_DATE and ACTUAL_LEAVE_START_DATE if not null. For e...ACTUAL_LEAVE_START_DATE and ACTUAL_LEAVE_START_DATE if not null. For example if ACTUAL_LEAVE_START_DATE = 2023-05-15 ACTUAL_LEAVE_START_DATE = 2023-05-29 The the days between would be 14 days Similarly if, ACTUAL_LEAVE_START_DATE = 2023-04-15 ACTUAL_LEAVE_START_DATE = 2023-06-1 The the days between would be 21 days Needs to be done ASAP, I will share the data for the table with you in excel and I want the query ...

Homepage: List all available Pokemon with pagination (20 Pokemon per page). Display each Pokemon's image, number, name, and types. Refer to https://www.po...Pokemon's image, number, name, and types. Refer to for layout inspiration. Statically render the first three paginated pages at build time. Render the remaining pages in real-time. Pokemon detail page: Display name, image, height, weight, classification, type, weakness, and resistance of the Pokemon. Include a button to open a popup showing the Pokemon's evolutions. Query evolution data only when the button is clicked, not beforehand. Refer to for an example of a Pokemon detail page. Statically render the detail pages for the first 20 Pokemon at build time.

Hello, I have a VPS where plesk stopped working and it's urgent to be fixed. This is the error: DB query failed: SQLSTATE[HY000] [2002] No such file or directory Please help urgently.

Keywords: Sigma Js, D3, Network link analysis, Graphocal Network analysis Please check above keywords to match your profile. We are seeking an experienced and motivated Network Link Analysis D...JanusGraph database. • Implement data visualization tools to represent analysis results. • Develop and maintain documentation for design, development, and implementation of solutions. • Provide technical expertise and guidance to team members and stakeholders. • Strong knowledge of graph database concepts and JanusGraph architecture. • Strong experience with data modeling, schema design, and query optimization. • Experience in data visualization tools and libraries such as D3.js or Cytoscape. • Excellent problem-solving and analytical skills. Intereste...

Hi i need one row htaccess query. i changed my website but it cant find files: old url (files will be found): new url, cant found: So i want just edit htaccess file so it shows pictures (.jpg) from old url. my budged $10

...details. List of items to be measured: • Topsoil excavation • Topsoil retention • Reduced level excavation • Disposal of excavated material • External trench excavation • Disposal of excavated material • Concrete in trench foundation • Brickwork below DPC (up to DPC level) • Blockwork below DPC (up to DPC level) Your submission should include: a. A taking off list b. Marked up drawings c. A query and answer sheet d. Measurement in the traditional dimension paper (approximately 800 words equivalent) Specification 600mm wide x 1500mm deep C20 mass concrete foundation footing. Taken down to 2.2m below structural floor level. Walls below ground 100mm semi engineering brick outer leaf. 100mm standard dense concrete block inner leaf bed...

I need help solving a slow MySQL query issue and creating a new multi-column database index for a large database table. The database structure I'm currently using is MySQL, I do have an existing database index for this table, but it needs to be improved. The size of the database table is between 1GB and 3GB. I'm looking for a reliable Freelancer who has experience in database optimization and can promptly address this issue.

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.