Sql query interview questions and answers pdf jobs

...Market Research and Mystery Shopping company. We undertake worldwide mystery shopping visits and audits. This assignment is an audit of an Examination Centre, checking that the security standards are being met. You MUST HAVE fluent English skills, and you must be able to communicate in a professional manner and be smart and well-presented, as you will be representing us during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, give your ID, show a letter of authorization, which we will provide for you beforehand, and tell them what you are there to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself...

I'm looking for a native American English speaker who can help me out with a project I'm working on. - **Type of Work**: This would involve a Zoom call, where you would be required to conduct an interview. - **Purpose of the Call**: The call will be recorded for the purpose of an audio project, so your role would essentially be that of an interviewer. Ideal Skills: - **Native American English Speaker**: This is essential for the project, as we're looking for an authentic voice. Data type: long audio conversation Data format: 48k 16bit two single sides + mixed (at least 32K) Content: You need to communicate around the 6 topics given, 25 minutes for each topic Male to female ratio requirement: one to one (adults over 18 years old) Number of people: 100 people in ...

...Market Research and Mystery Shopping company. We undertake worldwide mystery shopping visits and audits. This assignment is an audit of an Examination Centre, checking that the security standards are being met. You MUST HAVE fluent English skills, and you must be able to communicate in a professional manner and be smart and well-presented, as you will be representing us during the audit. As an auditor, you will arrive at the test center an hour before the start of the exam, give your ID, show a letter of authorization, which we will provide for you beforehand, and tell them what you are there to do. You will then sit with the TCA or the manager and ask a series of questions, and ask to see various things. The audit itself...

I am currently facing an issue with my website - when a user registers on the site, instead of being redirected to their profile page or login page, the system keeps them on the same page. Furt...keeps them on the same page. Furthermore, upon this failure to redirect, it shows it is successful when registering but doesn't take to another page. I need someone with strong proficiency in HTML, CSS, JavaScript, PHP, and SQL to diagnose the problem and implement a solution so that after successful registration, users are seamlessly taken to their profile page. The ideal candidate should have: - Significant experience in PHP, HTML, CSS, JavaScript, and SQL. - Proven track record in troubleshooting and rectifying website issues. - Firm understand...

...designing an automation focused Telegram bot. The main purpose of this bot is task automation, and primarily, it should be equipped with the functionality of responding to user inquiries. Key requirements and tasks include: - Construction of bot with the ability to automate responses to user inquiries. - Integration of a reliable system for the bot to search through a database for pertinent answers. The ideal freelancer would possess the following skills and experience: - Strong expertise in creating task automation bots for Telegram. - A sound understanding of databases and utilising them effectively to deliver appropriate responses to inquiries. - Ability to deliver an efficient, responsive and accurate bot. Your practical experience in th...

#1 Install FREE AI Chatbot so organizations can be matched with freelancers and create a quiz to match up 3 freelancers with every organization. Questions will be categorized by 3 categories. - General FAQs - Freelancer How to Get Started - Organization Matched up with 3 Freelancers #2 Freelancers and organizations can use FREE Chat gpt to create their profiles and project requests #3 Improve the website speed from C to A.

I need a data entry freelancer who can help me transfer 100 emails onto my website. - I'll provide you with the source of the data in PDF format. - You'll need to accurately copy and paste the emails onto the designated sections on the website. - The data should be organized in a way that's user-friendly for visitors. Ideal skills for this job include: - Proficiency in data entry, particularly copying and pasting. - Attention to detail to ensure the emails are transferred correctly. - Familiarity with website data entry would be a plus, but not mandatory.

I'm in need of someone skilled in PDF file structures who can determine if a particular PDF has undergone editing, and to identify the edited segments. To help successfully complete this task, you should: - Have in-depth experience navigating the structure of PDF files. - Capably discern changes or alterations made to a PDF. - Provide a report indicating any modifications, where they occurred. When applying, please exclusively focus on detailing your experience with manipulating PDF file structures. Past projects involving this will be highly advantageous. Ideally, you will have worked on similar projects, where the goal was to detect alterations in the document. Looking forward to a seamless collaboration.

hello amazon sp installation do you have apibilgi When we query with asin, can we retrieve information about the products? Example: B01234345 brand, sales, ranking, seller, number of offers etc. information

...with the aim to segment and profile the churners in Customer Churn file. By applying the k-Means clustering you need to explore how many types of churners exist and what characterizes those types. More specifically, this assignment consists of two tasks:  Task a (Segmentation): Establish how many types of churners there are and the size of those types. This involves dividing the churners into segments.  Task b (Profiling): Profile and appropriately name the identified types of churners based on the values of their shared characteristics, i.e. variables. Your submission ought to include: 1. Orange workflow1 containing the k-Means clustering analysis of segments and profiles. 2. Summary file (max. 600 words; in PDF format) presenting the segmen...

Experts r...yet this could potentially extend to long-term support. Key Responsibilities: - Create a robust, scalable, and highly interactive web application. - Develop efficient and reusable code that drives complex web applications. - Maintain a deep understanding of Angular + Laravel to optimize application capabilities. Ideal Skills & Experience: - Advanced proficiency in Angular + Laravel development. - Proven record of building highly interactive web applications. - Understanding of user roles for a web app is preferable. - Skilled in troubleshooting and improving existing and in-development applications. Time Frame: Since there were no specific answers regarding user roles and completion time, flexible freelancers open to d...

...lights, and simple motors and other simple devices. - The analysis should cover both the collective consumption of groups of devices and the individual consumption patterns of each device. Ideal Experience: - Strong background in Machine Learning, ideally with experience in real-time data analysis. - Previous work in energy consumption analysis or similar fields would be a huge plus. - Proven track record in developing ML models for group and individual level analysis. The ML analysis we are looking for includes: - Identifying energy usage patterns to help us understand consumption trends. - Implementing anomaly detection techniques to flag any irregular or unexpected behavior in our system. - Providing actionable recommendations for energy optimization b...

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I need an expert in SQL Server Report Builder 3.0 to help rejuvenate some lab reports. I require some amendments to be made to the current reports I have. Key Tasks: - Altering the way data is presented within the reports - Incorporating new fields to the current reports In the end, I need the same data results but with improved visibility and understanding. Ideal Skills: - Appropriate familiarity with SQL Server Report Builder 3.0 - Strong grasp of data visualization principles - Detail-oriented and precise to ensure report data remains accurate. Individuals that can deliver these changes precisely and quickly are highly preferred.

...project. - Video, 3D Tour: Incorporate video and 3D tour to enhance the user experience. User Experience for Lead Generation: - Contact Form Submission: Users should be able to submit inquiries through a contact form. - Direct Email or Call Option: Provide means for users to directly contact us via email or phone. - Schedule a Visit or Appointment Feature: Allow users to schedule visits or appointments. - Button for Download PDF Brochure: Include a downloadable PDF brochure about the project. Skills and Experience: - Proficiency in website development, particularly for real estate. - Experience in implementing interactive floor plans and 3D tour. - Strong understanding of lead generation and user experience. - Capability to integrate Google Ma...

I'm in search of an experienced developer skilled in Zendesk API integration...in Zendesk API integration for a project related to airline claim forms. I will provide you parts of the template and you will add the form, calculations, API integration and ticket creations. The website should be built in Laravel or secure platform. If you know about EC261 claims it makes it way easier to choose you. You will do the following: - Create a form which is predefined through parameters and questions. - Add airline and airport database and organize the data with live search preview. - Calculations based on airport distance and claim form. - Zendesk ticket creation along with correct ticket numer and relevant information. - Multilingual f...

I'm in search of a nutritionist who can provide both personalized meal plans and nutritional counseling, primarily for individuals seeking weight loss. Key requirements: - Designing customized meal plans: Including a diet that can assist with weight loss. Meal plans should be practical and easy to follow. - Nutritional counseling: Providing insights on healthy eating, lifestyle changes in support of weight loss goals. This might include tips on portion control, food choices, etc. - Delivery: You should be able to deliver the meal plans and conduct counseling sessions in written formats (PDF, Word, etc.). -Basically I am allergic to citrus fruits and apple so it would be better if don’t include those things in the diet plan. Ideal candidates ...

...should be in PDF format and written in English. "Rqeem Valuation & Consulting is a certified entity by TAQEEM for providing business as well as machinery & equipment valuations for different purposes such as M&A transactions, internal decision making, litigation, and financial reporting. As a member of the Saudi Authority for Accredited Valuers (Taqeem), our enduring leadership, collaboration, and focus on anticipating what the future looks like for our clients has positioned us as a trusted partner in the industry." Key Requirements: - The company profile should be compelling, engaging, and concise, tailored to attract potential customers and establish a positive image of the company. - Essential sections to be included a...

I need a skilled freelancer to extract table data from a PDF file. The extracted data will be used for analysis in a Microsoft Excel spreadsheet. Key Requirements: - Extract tables from a PDF - Ensure data quality and integrity - Deliver the data in a Microsoft Excel format Ideal Skills: - Proficiency in PDF data extraction - Strong understanding of table structures - Experience in working with Microsoft Excel - Attention to detail and accuracy is crucial look attached PDF and EXCEL then Bid, start Bid writing PDF and sample attached. So I know you look my file

I'm urgently looking for a professional who can create a customizable resume builder for me. It needs to be a simple and effective tool that allows users to easily input their information and then customize which sections and responsibilities they want to include in their resume. As I have experience in multiple industries and blended roles (i.e. Human Resources and Safety), I need to be able to select the responsibilities or accomplishments I wish to include for each past employer. I need to reduce my 5 page resume and tailor each resume for each employer. Currently spending an hour or more to tailor each resume. Key features: - Customizable sections - Ability to choose responsibilities to add for each employer from a list of responsibilit...

AUTO-BIDS WILL BE REMOVED. I'm in search of an experienced developer skilled...skilled in Zendesk API integration for a project related to airline claim forms. I will provide you parts of the template and you will add the form, calculations, API integration and ticket creations. The website should be built in Laravel or secure platform. If you know about EC261 claims it makes it way easier to choose you. You will do the following: - Create a form which is predefined through parameters and questions. - Add airline and airport database and organize the data with live search preview. - Calculations based on airport distance and claim form. - Zendesk ticket creation along with correct ticket numer and relevant information. - Multi...

Assist in writing answers for 3 questionnaires for Grant application criteria for an Allied Health Company demonstrating the company's setup All answers for the criteria's are to be written within 750 word limits each. Assessment Criterion 1: Service delivery [750 word limit] Describe how your organisation will deliver the services in the identified ACPRs in the application. Assessment Criterion 2: Stakeholder Engagement [750 word limit] Describe how your organisation will cultivate or expand links with other service organisations, infrastructure and resources, including the Regional Assessment Services (RAS) and other relevant specialist services e.g. dementia supports. Assessment Criterion 3: Efficient and Effective Use of Grant Funds [75...

I'm in search of an experienced developer skilled in Zendesk API integration ...skilled in Zendesk API integration for a project related to airline claim forms. I will provide you parts of the template and you will add the form, calculations, API integration and ticket creations. The website should be built in Laravel or secure platform. If you know about EC261 claims it makes it way easier to choose you. You will do the following: - Create a form which is predefined through parameters and questions. - Add airline and airport database and organize the data with live search preview. - Calculations based on airport distance and claim form. - Zendesk ticket creation along with correct ticket numer and relevant information. - Multi...

I'm in need of a skilled typist who can help me convert my PDF documents into editable text. The primary language of the documents is English. Requirements: - Type all the content in the PDFs accurately into a Word or Google Docs file. - Ensuring that there are no typographical or grammatical errors. - No specific formatting is needed, just plain text. Ideal Skills: - Proficiency in English language. - Fast typing speed with high accuracy. - Experience in PDF to Word/Google Docs conversion.

...templates. The goal is to enhance the visual quality of our interview videos. Key requirements: - Professional & Sleek: The templates should match the channel's theme of professionalism and sleekness. - Subtle & Integrated: The handling of text and graphics should be subtle and integrated, without overpowering the video content. Ideal skills and experience: - Proficiency in green screen design - Prior experience in creating templates for YouTube or similar platforms - Ability to understand and work with a professional and sleek design style - Expertise in subtle and integrated text and graphic placement Your work will play a critical role in enhancing the quality of our channel's content and viewe...

I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.

...proposal in a modern and professional manner. Key Points: - The design of the Business Proposal should be modern. - It should include high-quality images that I have ready to provide. - The final output of this project should be in a digital format such as a PDF. Ideal Skills and Experience: - Proficiency in InDesign or similar design software. - Experience in creating visually appealing Business Proposals. - Strong eye for modern design and layout. - Ability to work with high-quality images. - Knowledge of digital document creation and formatting. Your task will be to take the existing content and images and create a visually appealing, modern Business Proposal that will impress potential clients and partners. Co...

I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.

...specific details and requirements of this project are carefully documented in the attached .PDF file. *** There is a keyword buried in the attachment that we mention clearly. Your bid proposal needs to include this keyword to demonstrate that you have taken the time to read the attached document carefully. Proposals that do not include the keyword are likely NOT to be considered because it shows a lack of interest in the details. IMPORTANT: We are a software development company and we've been doing marketing and hiring graphics designers here on Freelancer for MANY years. This is not a difficult project. We are only asking for 1 or 2 or 3 graphics which as simple in nature. We are not asking for the next Mona Lisa here. Please note that we often ...

I am currently in need of comprehensive, multi-faceted telemedicine...multi-faceted telemedicine services to significantly enhance the accessibility, convenience, and cost-effectiveness of healthcare. Ideal candidates or companies for this project would possess: - Proven experience in the telemedicine field. - Examples of past work. - Detailed proposal showcasing their proposed approach to the project. Though the answers to what specific type of telemedicine service I'm looking for remain unanswered, a proficient provider should be equipped to offer a broad range of services, particularly in the following areas: - Virtual consultations - Remote patient monitoring - Diagnostic services Telehealth in New York. Must have providers onboard and...

...must have 5 rows of spectators around it, the texture and colors of the grass on the playing field must be light green like the attached examples, and in the same way with rounded corners like the examples, the two goals with the same style similar to the examples, the white lines inside that define the different areas as well. The playing field must also have a mesh or glass around the white perimeter line since the ball in the video game will not come out, there will be no throw-ins or corners. The dimensions of the playing field must have enough space for 18 players. of normal size are inside and do not create the impression that they are very close together. The floating island effect should be like the attached examples, the rock and water textures gener...

I'd like to replace the answers in these files - from words to images. For example, instead of the word "Beach" - to replace it with a photo of a beach.

I'm in need of a talented graphic designer who can create a design for our personalized beer glasses. Framework: - Output file as Vector file. - only two colors: The white design on a brown background - No need to place it on the beer glass; just show us the design - Design size: 3-inch wide x 3,5 inch tall. It can be oval, rectangle or something in betwee...Output file as Vector file. - only two colors: The white design on a brown background - No need to place it on the beer glass; just show us the design - Design size: 3-inch wide x 3,5 inch tall. It can be oval, rectangle or something in between - Must include the text " Alexander's Beer Glass" - This is not a Logo design; do NOT send me designs on business cards!!! Let me know if you have any questions. Tha...

I need an experienced AutoCAD professional to convert 4 hand-drawn sketches to accurate, scaled engineering blueprints. Requirements: - The focus will be on creating basic outlines with dimensions,...scaled engineering blueprints. Requirements: - The focus will be on creating basic outlines with dimensions, as opposed to full detail or annotations. - The sketches will need to include Mechanical Symbols. - Additionally, I need a PDF copy of each sketch, scaled to 11"x17" paper size. Ideal Skills and Experience: - Proficiency in AutoCAD for creating engineering blueprints. - Familiarity with Mechanical Symbols and notations. - Ability to work from basic hand-drawn sketches to generate high-quality, accurate plans. - Previous experience in creating scaled...

I have a Microsoft Word document that I need converted to PDF. The process involves converting the content of the Word doc into a PDF file while preserving all the images within the document. Ideal Skills and Experience: - Proficiency in Microsoft Word and PDF conversion - Attention to detail to maintain original document layout - Experience with image preservation during document conversion - Familiarity with different formatting requirements between Word and PDF

...Zoho and Odoo. Key Responsibilities: - Outbound calling to potential clients and setting up appointments for ERP product demonstrations - Maintaining a high level of professionalism and customer service during all interactions - Tracking and reporting on all appointments set, including relevant client information While it's not a strict requirement, preference will be given to candidates with experience in Zoho and Odoo, as they will be able to provide a deeper insight into our ERP solutions and potentially answer any preliminary questions that may arise. Ideal Skills and Experience: - Proven experience as an outbound appointment setter, preferably in the tech industry - Strong communication and negotiation skills ...

I need a comprehensive HTML/CSS solution for my report pages. it must be clean code with easy names class and id's not generated with ai Key Requirements: 5 pdf files not just this one . - Create inputs: I'm in need of a web developer to build inputs that can be used to create a real report. - Input types: The report inputs should include text, number, and date inputs, as well as checkboxes and tables. - Layout: The layout of the report pages should be exactly as shown in the sample page I will provide. Ideal skills for this job include: - Proficiency in HTML, CSS, and JavaScript. - Experience with form creation and layout design. - Attention to detail to ensure the layout is replicated accurately. i have x5 reports needed to be don...

I'm looking for a skilled transcriptionist to convert my lengthy PDF manual into a typed format. Here are some key details: - The manual exceeds 100 pages, making the task time-consuming and demanding attention to detail. - The manual is text-based, with tables and diagrams. A Procedure Manual. The ideal candidate will: - Have prior experience in transcription, specifically with lengthy documents. - Be proficient in English, ensuring an accurate transcription. - Be detail-oriented and able to maintain high standards throughout the task. Ensuring the accuracy and completeness of the transcription is crucial. This will be the foundation upon which other team members will build on.

...graphic designer to create a modern and minimalistic design for a set of scripture cards. These cards will be used as gifts for friends and family, so I'm aiming for a design that is simple and elegant. Key Requirements: - Modern and minimalistic design: The style of the cards should be clean, contemporary, and uncluttered. - Experience with typography: Prior experience with text design would be highly advantageous. - Understanding of gifting culture: A keen understanding of what makes a gift special in the eyes of the receiver, and how design can contribute to that, will be a big plus. Deliverables: I'm open to suggestions on the format for the scripture cards. I'm looking for your expertise on the most suitable format for thes...

Physical testing is to automated where test paper to be conducted online on computer lab. a Software is to be required for this purpose which has following functionality : 1. Preparation of Question bank (MCQ as well as descriptive.) 2. Preparation of Question paper based on question bank (questions to be selected randomly according to the weightage, level of difficulty etc.) 3. Showing result of MCQ part. 4. result preparation etc.

...a software developer to create a comprehensive solution for organizing and managing computer-based tests. Key Features Needed: - User Registration and Login: The software should allow for the creation and management of user accounts. - Question Bank Management: It needs to support the management of a database of test questions. - Test Scheduling and Timer: The software should also provide scheduling for tests and a timer feature for exam sessions. - Setting of Question Paper: The system should have a feature to set up question papers for each test. - Intuitive GUI for Examinee: A user-friendly graphical interface for test takers. - GUI for Result Preparation: Additionally, a graphical interface for staff to prepare and analyze results. ...

I'm seeking a freelancer to assist with editing a PDF file. The project involves modifying both the text content, numerical data, and the graphical sliders within the document. Key Responsibilities: - Editing of text data within the PDF file. - Modification of numerical data. - Updating the graphical design of sliders/scales. You should be proficient in PDF editing and manipulation tools, as I already have the necessary software. Additionally, experience with modifying and designing graphical elements within PDF files is crucial. The ideal candidate should possess a keen eye for design, ensuring the graphical sliders are visually appealing and functional. Please share any relevant experience with similar projects in your prop...

I am looking for a skilled and experienced Full stack developer with Hands-on experience in Java Hands-on experience in Angular/ REACT Hands on experience on AWS RDS/AWS S3/Oracle/AWS Athena/ SQL In-depth knowledge in Core Java, Spring framework and RESTful API Services, Apache Camel, CI/CD Jenkins, Containerization Experience with AWS Cloud and its services like EC2, Athena, Lambda, S3, SQS and Cloud Formation Experience in writing JUnit test cases Problem-solving abilities

I have an immediate requirement for experienced freelance recruiters who can help me recruit content moderators and customer service advisors in Portugal, Greece, and Spain. Key Details: - Positions: Content Moderation, Customer Service Advisors - Language skills: Fluent in French, German, Dutch, Italian, Norwegian, and Swedish all + English Ideal Skills and Experience: - Proven experience in recruiting for customer-facing roles. - Ability to source and interview candidates who are fluent in several languages. - Exceptional knowledge of European job markets, particularly in Portugal, Greece, and Spain. - Extensive network of multilingual professionals. Looking forward to connecting with high-performing recruiters who can source the right...

...wonder and teenage independence. Museums, with their vast collections and interactive exhibits, can be the perfect playground to ignite this curiosity and equip them with valuable life skills. But how do we transform a museum visit from a passive stroll to an active learning experience? This blog delves into life skills activities that pre-teens can engage in at museums, turning a casual outing into a springboard for future success. Unleashing the Inner Communicator: Debate Club in the Dioramas: Museums often have dioramas depicting historical events or ecosystems. Divide your pre-teens into groups and assign them opposing viewpoints related to the scene. Encourage them to research and prepare arguments based on the exhibit information. This fosters ...

...creative and experienced video creator who can produce a 8-12 minute Youtube video. The video will be aimed at a general audience, so it should be engaging and accessible for all ages. The main content of the video will be Bible quizzes, consisting of multiple choice questions. Skills and experience in the following areas are desired: - Video editing - Scriptwriting - Creating engaging and informative content for a general audience The ideal freelancer for this project will be able to produce a high-quality, professional video that is both entertaining and educational. Provide direct links to your work related to his project. !No links - no consideration and project will be removed from bids. Please don't ask me to search you...

...Experience in a leading-edge field of training Artificial Intelligence - Work for an advance American IT company - Free training provided by the company and the Client - Creative and dynamic tasks, very different from monotonous translation Your assignment: The tasks will contain a question and 2 answers to it written in Japan. All instructions will be provided in English. 1) You will evaluate these 2 answers across 6 categories (safety, writing style, verbosity, followed instructions, truthfulness, overall quality). For example, “safety” indicator means presence of toxic or offensive language and so on. 2) You will compare the two statements and decide which one is a better answer to the question 3) You will provide a bri...

...should be visually appealing and on-trend, suitable for a diverse audience. Key Points: - The design should be original and unique, tailored to the t-shirt medium. - I'm open to different design types, but high-quality and innovative concepts are preferred. - Please showcase your previous t-shirt design work, particularly anything that demonstrates your ability to create marketable designs. - A deep understanding of current design trends and the ability to create trendy, eye-catching designs is a huge plus. - Experience with typography, illustration, and graphic design are all welcome. Please submit your application with a brief overview of your design approach, relevant past work, and any specific ideas you have for this project. Feel fr...

...advertising platforms, website activity, CRM, and Marketing Automation Platforms (MAP) to provide a unified view of marketing performance. We require a highly skilled and efficient Data Engineer or Architect who can handle data export processes, model and create tables and entity relationships, and develop an efficient and scalable database within a tight one-month deadline. ### Responsibilities: - Data Integration: connect and streamline data from multiple sources including ad platforms (like Google Ads, Facebook), website analytics tools (e.g., Google Analytics), CRM systems (e.g., Salesforce), and MAPs (e.g., HubSpot). - **Accelerated Database Design:** Design and implement a robust and scalable database that supp...

...Please look the .PDF file have a full details of this simple project. I need this assistance Today or tomorrow day 19 or day 20 max limit.. If you can do this now....I prefer. The old website was on WordPress, but the guy used ACF and created some custom fields for company employees to register stores separated by state and city. There's also something about taxonomy; he created 2 custom post types: 'office' and 'officearea.' In the old WordPress, it worked like this: 1 - User goes to the offices menu, where all states are listed. 2 - User chooses a state, and that state's name is in the URL. 3 - It seems the guy made a PHP script that retrieves the chosen state from the URL, then loops through and displays only...